Thank you all for taking the time to answer this.

This is what ended doing:

SELECT Location,startdate,enddate,
SiteList = (SELECT ',' + Site  FROM tblsiteSchedule...

Thanks all for your reply.
Group by won't work you're still pulling all four records.

The second option, I would have to do it for every single record. Just...

Thank you very much for your response.

The table that I'm working with doesn't have dates.

I tried your example "as is",

I created the function and then run the code below

--...

2015-10-01 to 2015-10-10 ---this will be week 1 for FY16, but it's recorded as 2015-41

2015-10-11 to 2015-10-17 ---this will be week 2 for FY16, but it's recorded as 2015-42

2015-10-18 to...

Thanks for your reply.

None of the dates will define week 1 for FY16

here are the definitions:

2015-10-01 to 2015-10-10 ---this will be week 1 for FY16, but it's recorded as 2015-41

2015-10-11...

First week starts at week 40, which is week 1 of the fiscal year

Week starts on sunday and on saturday.

Fiscal year starts October 1.

Thanks

Thanks for the reply. I can't do changes to database. Change requests take very long for approval and implementation.

Did anybody find the answer for this issue?

I unchecked the "Grant" next to the "sa" under the "Permissions" for the public server role. Now everytime I click on Permissions, I...

Oops...Thank you very much! that did the trick!

Why cursor? cursors seem to do what i need...

Thanks again for the prompt response