>>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 >>*/ >>>>