How can I join derived table

Question

How can I join derived table

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

GilaMonster (11/25/2008)
I didn't ask for the entire proc. I said, if you want us to do all of the work for you, give us table definitions (as create table statements), sample data (as insert statements) and your desired result.

Ah geez, you didn't want to do the rewrite based on the original code?

Actually, it is pretty long, and probably not the best way to figure out what needs to be done.

(P.S. Glad to have you back on the site. Hope you enjoyed your time here in Seattle!)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Lynn Pettis (11/25/2008)
(P.S. Glad to have you back on the site. Hope you enjoyed your time here in Seattle!)

Loved every minute of it. I just got back to SA 3 hours ago.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736059 More actions · Answer 3

That's a lot of code.

Derived Tables - http://www.sqlservercentral.com/articles/DerivedTables/61388/

You might need to make two updates if you can't get it done in one. Gail has given you good hints, and you might want to spend a bit of time working with them to try and move things around.