Hi,
Below is code to gather information from a beg and end date but hwo would I generate information on each day of the week. Sunday - Saturday for a set of specific date ranges?
Select
Count(b.max)
From
lm.dw a,
lm.bw b
Where
(a.Start_dt <= getdate() and a.End_dt >= getdate())
and (b.pic_x= a.pic_x);
Select
Count(b.max)
From
lm.bw b;