SET DATEFIRST 1
;WITH days(Date) AS 
(
	--Get 13th of this month
	SELECT CAST(CAST(YEAR(GETDATE()) AS VARCHAR(4)) + '-' + CAST(MONTH(GETDATE()) AS VARCHAR(2)) + '-13' AS DATETIME)
	UNION ALL
	--Get 13th of next months
	SELECT DATEADD(MONTH, 1, Date) FROM days 
)
SELECT TOP 1 * FROM days WHERE DATEPART(dw, Date) = 5 AND Date > GETDATE()

SET DATEFIRST 1
;WITH days(Date) AS
(
    --Get 13th of this month
    SELECT CAST(CAST(YEAR(GETDATE()) AS VARCHAR(4)) + '-' + CAST(MONTH(GETDATE()) AS VARCHAR(2)) + '-13' AS DATETIME)
   UNION ALL
   --Get 13th of next months
   SELECT DATEADD(MONTH, 1, Date) FROM days 
)
SELECT * FROM days
SELECT TOP 1 * FROM days WHERE DATEPART(dw, Date) = 5 AND Date > GETDATE()

 SELECT TOP 1
        DATEADD(dd,N-1,GETDATE())
   FROM 
        Tally
  WHERE 
        n < 366 --== One years worth of days
    AND 
        DAY(DATEADD(dd,N-1,GETDATE())) = 13 
    AND 
    --==
    --== Using @@DATEFIRST and the modulus operator we don't need to change or 
    --== assume anything about the current DATEFIRST setting
    --==
        (@@DATEFIRST + DATEPART(dw,DATEADD(dd,N-1,GETDATE()))) %7 = 6
ORDER BY 
        N

with thirteen (thedate) as(
select cast('01/13/1753' as datetime) as thedate
 union all
select DATEADD(mm, 1, thedate)
  from thirteen
 where thedate < '01/01/9999'
)
select year(thedate) yr, 
       count(*) cnt
  from thirteen
 where DATENAME(dw, thedate) = 'Friday'
 group by year(thedate)
having count(*) = 3
OPTION (MAXRECURSION 0)

    SELECT 
            YEAR(DATEADD(mm,N-1,'17530113')),
            COUNT(*)
      FROM
            dbo.Tally
     WHERE 
            N < DATEDIFF(mm,'17530113','99990101')
       AND 
            DATENAME(dw, DATEADD(mm,N-1,'17530113')) = 'Friday'
  GROUP BY 
            YEAR(DATEADD(mm,N-1,'17530113'))
    HAVING 
            count(*) = 3
  ORDER BY 
            YEAR(DATEADD(mm,N-1,'17530113'))