• Yeah I like the last approach, I'd probably have used datepart(dw,yourdatecolumn) =6 but that is dependant on the day offset, better using Datename, and it is easier to read.

    But it does highlight the lack of clarity in the question:

    Do you want a query that will give you the dates of all the first fridays of the month for 2014 to 2015

    OR

    do you have records that you need to filter to just those with a yourdatecolumn that falls on the first friday of the month for 2014 to 2015 ?

    Hence you get two quite different answers.