February 27, 2008 at 6:33 am
Michael,
You are correct. You have to go with derived tables on 2000 as CTE's were introduced in 2005.
Jeff,
Always appreciate some code review:P
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 27, 2008 at 7:48 am
Jack Corbett (2/27/2008)
Jeff,
Always appreciate some code review:P
All right - I'll go with that. Jeff- you need to pick your "number". You know - so that we can say that this was "inspected by #??".....:w00t::P:D:hehe:
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 27, 2008 at 8:54 am
77...
--Jeff Moden
February 27, 2008 at 9:00 am
Nice #. Ray Bourque.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply