bitbucket-25253 (3/16/2010)
GRE (Gethyn Ellis)Thanks for the feed back. Edited my posting to add 2 additional scripts would you be so kind as to give them a test.
Again I thank you ,and so will the original poster of the question and any others who stumble upon this forum.
Both additional Scripts run OK on 2008 against the AdventureworksDW db on SQL2008
The very first script (Script 1) returned 88 rows
The 2nd script (Script 2) returned 78 rows -- for some reason I was expecting this to more than the first script?
The final script (Script 3) returns 122 rows
Gethyn Elliswww.gethynellis.com