Thread: TSQL: conditional union statement
View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 07:44 PM
David Portas
 
Posts: n/a
Default Re: conditional union statement
SELECT *
FROM territories
WHERE regionid = 1
OR (regionid = 2 AND @both = 1)

--
David Portas
------------
Please reply only to the newsgroup
--


Reply With Quote