... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 17,676 of 19,505

Plamen Ratchev to All

Re: Grouping unions in sqlserver 2005

26 Oct 09 09:54:19

   f70f3b88   
   From: Plamen@SQLStudio.com   
      
   You can use a derived table:   
      
   SELECT code, description, SUM(qty), SUM(amount), SUM(costprice)   
   FROM (   
      
   UNION   
   ) AS T   
   GROUP BY code, description;   
      
   --   
   Plamen Ratchev   
   http://www.SQLStudio.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]