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