Using the date table function on the link below, here are the queries you can use.

Date Table Function F_TABLE_DATE

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

select

Sunday = [Date]

from

F_TABLE_DATE('08/01/2014','08/31/2014')

where

-- Select Sunday

ISO_DAY_OF_WEEK = 7

select

Monday = [Date]

from

F_TABLE_DATE('08/01/2014','08/31/2014')

where

-- Select Monday

ISO_DAY_OF_WEEK = 1

Results:

Sunday

-----------------------

2014-08-03 00:00:00.000

2014-08-10 00:00:00.000

2014-08-17 00:00:00.000

2014-08-24 00:00:00.000

2014-08-31 00:00:00.000

Monday

-----------------------

2014-08-04 00:00:00.000

2014-08-11 00:00:00.000

2014-08-18 00:00:00.000

2014-08-25 00:00:00.000