G
Gary Nelson
In Acces 2000, I trying to write a stored procedure in order that I can
provide a breakdown of the number of "jobs" completed by day - Monday
through Friday. I have been successful in writing the code below which
gives me the jobs completed on Monday, but am uncertain how to write the
code for Tuesday through Friday. Please help...
Thanks in advance for your assistance.
Alter Procedure spAPKJobsBoundByDay
as declare @monday smalldatetime
set @monday = DATEADD(DAY, 2-DATEPART(DW, {fn CURDATE()}),{fn CURDATE()})
select dbo.bookall.jobnum, dbo.bookall.datein from dbo.bookall where
dbo.bookall.datein =@monday
provide a breakdown of the number of "jobs" completed by day - Monday
through Friday. I have been successful in writing the code below which
gives me the jobs completed on Monday, but am uncertain how to write the
code for Tuesday through Friday. Please help...
Thanks in advance for your assistance.
Alter Procedure spAPKJobsBoundByDay
as declare @monday smalldatetime
set @monday = DATEADD(DAY, 2-DATEPART(DW, {fn CURDATE()}),{fn CURDATE()})
select dbo.bookall.jobnum, dbo.bookall.datein from dbo.bookall where
dbo.bookall.datein =@monday