DECLARE @LoopDate AS DATETIME
SET @LoopDate = CAST('2011-01-01' AS DATETIME)

SELECT
CONVERT(CHAR(10),
DATEADD(wk,2,(@LoopDate -
Day(@LoopDate)+1)+(6-DATEPART(dw,(@LoopDate -
Day(@LoopDate)+1)))),
121)

2011-01-14

 SELECT CASE
            WHEN GETDATE() <= CAST(DATEDIFF(dd,-3,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))/7*7+4+14 AS DATETIME) --3rd Friday Current Month
            THEN CAST(DATEDIFF(dd,-3,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))/7*7+4+14 AS DATETIME) --3rd Friday Current Month
            ELSE CAST(DATEDIFF(dd,-3,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0))/7*7+4+14 AS DATETIME) --3rd Friday Next Month
        END

BEGIN -- Show each 3rd Friday for 2010 and 2011.
DECLARE @LoopCounter AS INTEGER
DECLARE @LoopDate AS DATETIME
SET @LoopCounter = 1
SET @LoopDate = CAST('2010-01-28' AS DATETIME) --  Whatever Date is Passed (month 1 for convenience)
SET @LoopDate -- Set @LoopDate to the 1st of the month.
    = CAST(CAST(YEAR(@LoopDate) AS VARCHAR(4))
                + '-' +
                CAST(MONTH(@LoopDate) AS VARCHAR(2))
                + '-' +
                CAST('01' AS VARCHAR(2)) AS DATETIME)

WHILE @LoopCounter <= 24
  BEGIN
  SELECT @LoopDate
        ,CASE -- Determine the 3rd Friday based on the first day of the month.
         WHEN DATEPART(dw, @LoopDate) = 1 THEN 20 
         WHEN DATEPART(dw, @LoopDate) = 2 THEN 19 
         WHEN DATEPART(dw, @LoopDate) = 3 THEN 18 
         WHEN DATEPART(dw, @LoopDate) = 4 THEN 17 
         WHEN DATEPART(dw, @LoopDate) = 5 THEN 16 
         WHEN DATEPART(dw, @LoopDate) = 6 THEN 15 
         WHEN DATEPART(dw, @LoopDate) = 7 THEN 21 
         END AS ThirdFriday
  SET @LoopCounter = @LoopCounter + 1
  SET @LoopDate = DATEADD(month, 1, @LoopDate)
  END
END
go