Viewing 2 posts - 1 through 2 (of 2 total)
--For those on 2005, and/or wanting a function suited for variable number of columns, below is an alternative. [I've not tested this widely.]
CREATE FUNCTION dbo.fn_DelimitedSplitN4K (@pString NVARCHAR(4000), @pDelimiter NCHAR(1))...
May 31, 2017 at 5:59 pm
#1944841
case when DATEPART(DW, SED.earlieststartdate) = 1 then 'Sunday' else
case when DATEPART(DW, SED.earlieststartdate) = 2 then 'Monday' else
case when DATEPART(DW, SED.earlieststartdate) = 3 then 'Tuesday' else
case when DATEPART(DW,...
October 24, 2013 at 9:44 am
#1661351