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

>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.