>I haven't ran them yet - need to work, but if you need datetime, then why do you declare @FirstSat as varchar(11) ?

Because I had a stupid moment. I changed it to DATETIME and it works fine. No clue why I did that.

:)





>
>>Ok, this is strange:
>>
>>

>>DECLARE @FirstSat VARCHAR(11)
>>
>>DECLARE @Temp VARCHAR(46)
>>SELECT @Temp = '2010-04-Apr'
>>DECLARE @DATE DATETIME
>> 
>>SELECT @DATE = LEFT(@Temp,7) + '-01'
>> 
>>SELECT TOP 1 @FirstSat = DATEADD(dd,number,@DATE)
>>	FROM master..spt_values
>>	WHERE type = 'p' AND
>>		  DATEPART(dw,DATEADD(dd,number,@DATE)) = 7
>>	ORDER BY 1 ASC
>>
>>SELECT @FirstSat
>>
>>
>>/*
>>
>>DECLARE @Temp VARCHAR(46)
>>SELECT @Temp = '2010-04-Apr'
>>DECLARE @DATE DATETIME
>> 
>>SELECT @DATE = LEFT(@Temp,7) + '-01'
>> 
>>SELECT TOP 1 DATEADD(dd,number,@DATE) AS FirstSat 
>>	FROM master..spt_values AS FirstSat
>>	WHERE type = 'p' AND
>>		  DATEPART(dw,DATEADD(dd,number,@DATE)) = 7
>>	ORDER BY 1 ASC
>>*/
>>

>>
>>Run both queries. They return different formats. I need back a DATETIME.