Need to edge out the competition for your dream job? Train for certifications today.
SELECT @Week = CASE WHEN d.name = 'gro' THEN t.Fri-4 ELSE t.Fri END
FROM prog p
Open in new window
Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
'TheWeek' = t.Fri,
'Dept' = d.name
FROM prog p
--Joins here --
WHERE @Week = case when dept = gro then t.Fri-4 else t.Fri end
WHERE (d.name = 'gro' AND @Week = DATEADD(D,+4,t.Fri))
Or (d.name = 'deli' AND @Week = DATEADD(D,+4,t.Fri))
Or (d.name = 'produce'' AND @Week = DATEADD(D,+4,t.Fri))
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.