December 21, 2009 at 7:31 am
NA
December 21, 2009 at 7:38 am
Not only that, and it may just be me, but it looks like the logic for the first and last row of data look the same.
December 21, 2009 at 7:42 am
Looks like a couple of simple selects inserted into a table variable. Are you familiar with how to write Insert...Select statements?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 21, 2009 at 7:44 am
What have you done so far? Even if this is homework you may still get help with it, especially if you can demonstrate a willingness to do at least some of the work. A script consisting of variable declarations and a table CREATE statement would be a fine start.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
December 21, 2009 at 8:45 am
Just a little bit rude, don't you think??
December 21, 2009 at 9:35 pm
BrainDonor (12/21/2009)
Have a look at their history - it isn't the first time they've done that.I don't think some people appreciate the hoops others are prepared to jump through to try and help them.
Heh... ok... I've seen this type of stuff before and I'm going to start quoting the OP from the git so when they pull this NA junk, we at least have a record. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:40 pm
PSGS (12/21/2009)
NA
3 posts... 2 deleted. Really bad form... 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply