[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
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
More information about the thelist
mailing list