sql - Get a particular day from a date range -

sql - Get a particular day from a date range -

how day date range?

for example:- if suppose have date range 22/june/2014 28/june/2014 want mon of date range ie, 23/june/2014 monday

ok got 1 working me.

declare @datefrom datetime = convert(datetime, '22/06/2014', 103) declare @dateto datetime = convert(datetime, '28/06/2014', 103) ;with cte(dt) ( select @datefrom union select dateadd(d,1,dt)from cte dt<@dateto ) select *,'monday' [day] cte datename(dw,dt) = 'monday'

sql sql-server sql-server-2008