>I have 96K rows with a Month column. The data is in the format:
>
>

YYYY-MM-Mon

>
>So, '2009-11-Nov' is November, 2009 and '2009-02-Feb' is February. The middle 2 charaters are the month number.
>
>I need to convert these to the first Saturday of the month. Anyone know of a way to do this?

SET DATEFIRST 7
DECLARE @TestMe varchar(20)
SET @TestMe = '2009-11-Nov'
DECLARE @TestDate as Datetime
SET @TestDate = LEFT(REPLACE(@TestMe,'-',''),6)+'01'
SELECT @TestDate,
       DATEPART(dw, @TestDate) AS DayOfWeek,
       DATEADD(dd,7-DATEPART(dw, @TestDate),@TestDate) AS FirstSaturday