[thelist] SQL Union and order by problem

[Luther, Ron]

XtiaN asked:


>>can anyone help me ?

>>select * From (
>>SELECT top 100 PERCENT a,b,c    
>>FROM tb
>>WHERE DATEDIFF(day, b ,getdate())>=3
>>order by b desc) asd
>>union all
>>select * From (
>>SELECT top 100 PERCENT a,b,c    
>>FROM tb
>>WHERE DATEDIFF(day, b ,getdate())<3
>>order by b asc) def


Hi XtiaN,


I think we have some folks who can help.

However, we might want to crosscheck and make sure we understand what
you want.

Do you really want a list of "Records that are more than 3 days old
descending by datetime stamp" added to a list of "Records that are less
than 3 days old ascending by datetime stamp"?

So if we run this query at 2pm on 18-Oct-2007 we _want_ to see something
like this???:

(Record 1) 15-Oct-2007 2pm
(Record 2) 14-Oct-2006 1pm
(Record 3) 11-Oct-2005 6pm
(...)
(Record n) 15-Oct-2007 3pm
(Record n+1) 15-Oct-2007 7pm
(Record n+2) 16-Oct-2007 4am

It just seems like a really odd thing to ask for.

I think if we better understand what you want the result to look like,
we can help get there.


Thanks,
RonL.