Okay, so I have a query like the attached.
I know today is MON so I want to put priority on my order by for tomorrows deliveries - (TUE)
But then when my script gets to TUE i want to put priority on WED and so on.
How can I do this with either SQL or C# to save me having to write out 7 different queries depending on the day of the week that the scripts is run?
Hope you can help.
"ORDER BY CASE bs.DeliveryDay" +
"when 'TUE' then 1" +
"when 'WED' then 2" +
"when 'THU' then 3" +
"when 'FRI' then 4" +
"when 'MON' then 5" +
"else 99" +
", bs.SOH DESC"