Environments can be accessed across folders. To see this, right click on a deployed project and select configure. Click references,Add... and you will be able to browse to other folder's...

rgldiatr (6/22/2012)

---

Another question. In your first CTE you have a cross apply:

CROSS APPLY (SELECT StartDt + n FROM Tally WHERE EndDt >= StartDt + n) x(date2)

What is the "x(date2)" part...

Another question. In your first CTE you have a cross apply:

CROSS APPLY (SELECT StartDt + n FROM Tally WHERE EndDt >= StartDt + n) x(date2)

What is the "x(date2)" part of...

Thanks! This has gotten me a lot closer. I made a couple of modifications to adjust the start date result and remove the xml tags. But this brought up...