Help for one query to solve

Question

Post reply

Help for one query to solve

kak.mca

Valued Member

Points: 71
More actions
February 28, 2011 at 9:55 pm

#234494

Hi everybody,
I always try to write different queries, but still problem. I CANNOT get glance on query writing. :crying:
Can anybody please tell how to write the query given in the following url? My colleague has given this exercise to me. Is there any special technique to write like this type of query?
The url is: http://beyondrelational.com/puzzles/tsql/1/english/pair-wise-and-ordered-assignment-of-objects-from-two-different-lists.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

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

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 1

Three hints...

CTE

ROW_NUMBER() OVER (PARITION BY ________ ORDER BY ________)

OUTER JOIN

Look those up in Books Online (the "Help" system that comes with SQL Server)

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 2

So did that help at all? Heh... "Enquiring minds want to know." 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)