[thelist] SQL Union and order by problem

[XtiaN]

Nice... It works!!!


thanks rudy ^^

r937 <rudy at r937.com> wrote: okay, i think i understand (maybe)

try this query --


     SELECT a,b,c    
          , case when DATEDIFF(day, b ,getdate()) >= 3
                 then 0
                 else 1 
             end          as which_group
     order 
         by which group asc
          , DATEDIFF(day, b ,getdate()) 

rudy
http://r937.com/

-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 


 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com