I need to write a DTS package which is date oriented and I'm having problems
getting something coherent. I'm not a big guy in SQL Server, so please excuse
my ignorance.

I need to get some sales information based on the previous day...however, if
the previous day was Monday, then I need to get the sales data for the
Friday. The where clause looks like this (and it's not
working....unsurprisingly).
/*****************************************
where
case upper(datename(dd,getdate())) = 'MONDAY'
then
ididat = getdate(dateadd(day,-3,getdate()))
--and ididat < 20060320
else
ididat = getdate(dateadd(day,-1,getdate()))
--and ididat < 20060320
end
/*****************************************

Any ideas?

Thx for your help

Hi Billy,

The first thing you might try is using 'dw' (no quotes) as the first
parameter to datename( ). This should return the string you're looking for.
Books Online (BOL) has a listing of valid params.

Andrew


"Billy" <Billy (AT) discussions (DOT) microsoft.com> wrote

Hello Billy,

Not tested

It should look something similar to

....
WHERE
CONVERT(CHAR(8),<date column>,112) =
CASE
WHEN DATENAME(dw,DATEADD(day,-1,Getdate())) = 'MONDAY' THEN DATEADD(day,-3,CONVERT(CHAR(8),DATEADD(day,-1,Getdate()),112))
ELSE CONVERT(CHAR(8),DATEADD(day,-1,Getdate()),112)
END



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com