[thelist] SQL Union and order by problem

XtiaN indotekken at yahoo.com
Thu Oct 18 22:14:31 CDT 2007

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
         by which group asc
          , DATEDIFF(day, b ,getdate()) 



* * Please support the community that supports you.  * *

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 

More information about the thelist mailing list