Ordered output for referenced columns

Question

Ordered output for referenced columns

arun1_m1

SSCommitted

Points: 1949
More actions
January 4, 2013 at 4:50 am

#272428

I have table with the following structure and datacreate table #temp (id int not null, refid int)
The refid column refers id column but there are no constraint as such till now.
Suppose the table has data as :-
id refid
1 2
2 NULL
3 NULL
4 3
I want the output as:-
id refid
1 2
2 NULL
4 3
3 NULL

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

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

unless you have a way of telling SQL the order, then you can only order on what you have so that would be the id or the refid.

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 2

Hi,

So just to confirm,

this is a parentt-child hierarchy and you wish to start at leaf nodes and work back to root ?

What would you expext to happen if the row , (5,2) were added to the data ?

Clear Sky SQL
My Blog[/url]

arun1_m1 SSCommitted Points: 1949 More actions · Answer 3

Thank you Dave for your reply, if it is 5,2 then it would be aftere 1,2. I think you have rightly pointed it should be like the parent-child query. I'm trying to figure out the query.

Thanks

Arun