Different sums from table

Hot Topic

unexpected result from LOOKUP
Code Access Security and File.Exists
Problem with creating a merge publication
interactive sort in group
Memory Error
Creating xsd schema file for a xml file ...
Is it possible to dynamically populate a parameter list with values based on another parameter value?
Error when browsing processed Cube
SQL2005 backup Issue
Taking reports backwards

SQL Server

What does TimeStart and TimeEnd signify in the ExecutionLog table
Execution of Package failed
Blank Row comming out from Excel Source?
Service Broker Activation
XML Data Sources Extension
I'd like to get a good book of SQL...
Management Studio Scripting Bug?
System::ExecutionID required in eventhandlers
Calling SSIS packages from within a Script task
Which sql statement is more efficient

Different sums from table

Could someone explain to me, how I can get sum from row which I have values in 2 colums and I want the realtime sum to third column. Fourth colum is for item.

Also can someone tell me how to sum these third colums where the item is same so I have real time values for the item sum.

Thanks!

AD




Answer this question

Different sums from table

  • vegasrockstar

    Hi,

    regardless that this makes no sense at all, this could be an example (as far as I understood your problem):

    Select OrderId, Sum(Unitprice) + Sum (Quantity) AS ThirdColumn

    from [Order Details]

    Group by OrderId

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Different sums from table
Answer this question