Viewing 3 posts - 31 through 33 (of 33 total)
Select * From [Vacation] Where Year(exitDate) like @year_month
and Month(exitDate) like @year_month
March 16, 2007 at 7:57 am
#695464
Management folder>jobs>right click>create new job>go to: 1.steps>new>choose database>command:>execute [db name].dbo.[your sp]2.schedule.
March 15, 2007 at 7:46 am
#695218
Very simple.
SELECT distinct (case when count(Pswrd)=0 then 'NoUser' end) as Result
FROM WHERE last = 'TEST02'
March 14, 2007 at 7:48 am
#694947