Databases
StackOverflow2013
Postsdbo
POAdding a descriptive/commenting column on query results
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAdding a descriptive/commenting column on query results
    primarykey
    data
    text
    <p>I want to add a descriptive column at the end of my query results. For example I have </p> <pre><code>SELECT sum(amount) as Balance FROM tbDebits WHERE CustomerID =@CustomerID; </code></pre> <p>Now if the Balance is positive I want to add another column called 'Description' in my query results describing each result as positive or negative. Any ideas?</p> <p>Here is my original query:</p> <pre><code>SELECT t.CustomerID, c.name, c.Surname, (SELECT ( (SELECT ISNULL(SUM(cashout),0)- ((select ISNULL(sum(Buyin),0) from [Transaction] where TYPE='Credit' and CustomerID=t.CustomerID ) + (select ISNULL(sum(Paid),0) from [Transaction] where TYPE='Credit' and CustomerID=t.CustomerID )) FROM [transaction] WHERE TYPE='Credit' AND CustomerID=t.CustomerID ) ------------------- + ( (SELECT ISNULL(SUM(cashout),0) - (select ISNULL(sum(Paid),0) from [Transaction] where TYPE='Debit' AND Cashout&gt;buyin and CustomerID=t.CustomerID ) + (select ISNULL(sum(Cashout),0)- (select ISNULL(sum(PAID),0) from [Transaction] where TYPE='Debit' AND Cashout&lt;buyin and CustomerID=t.CustomerID ) from [Transaction] where TYPE='Debit' AND Cashout&lt;Buyin and CustomerID=t.CustomerID ) + (select ISNULL(sum(Cashout),0)- (select ISNULL(sum(PAID),0) from [Transaction] where TYPE='Debit' AND Cashout=buyin and CustomerID=t.CustomerID ) from [Transaction] where TYPE='Debit' AND Cashout=Buyin and CustomerID=t.CustomerID ) FROM [Transaction] WHERE CustomerID=t.CustomerID AND TYPE='Debit' AND Cashout&gt;buyin ) ) -------------- - ( select ISNULL(sum(Paid),0) from [Transaction] where type='Debit Settlement' AND CustomerID =t.CustomerID ) -------------- + ( select ISNULL(sum(Paid),0) from [Transaction] where type='Credit Settlement' AND CustomerID =t.CustomerID ) )) as Balance FROM [Transaction] as t inner JOIN Customer AS c on t.CustomerID = c.CustomerID GROUP BY t.CustomerID, c.name, c.Surname </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USalwaysVBNET
    1. USalwaysVBNET
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAdding a descriptive/commenting column on query results
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POAdding a descriptive/commenting column on query results
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POAdding a descriptive/commenting column on query results
      1. This table or related slice is empty.
      1. VTUndeletion
    1. COTo do this in SQL, you need a `CASE` statement. Why are you trying to do this though - what's the point?
      singulars
      1. POAdding a descriptive/commenting column on query results
      1. USClockwork-Muse
    2. COJust a customer requirement.
      singulars
      1. POAdding a descriptive/commenting column on query results
      1. USalwaysVBNET
    3. CO@Clockwork-Muse I tried to use the CASE statement I just had troubles using the 'Balance'. An example would be highly appreciated. To be honest, the 'Balance' is a result of many queries and subqueries so I was getting errors that I can't use case when I have multiple subqueries.
      singulars
      1. POAdding a descriptive/commenting column on query results
      1. USalwaysVBNET
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload