CODEWITHSUNDEEP
sqlasp.net
KMurray
KMurray

Reputation: 79

SQL to Sum columns in a row

I have an sql that gives me this data:

    Dim MySqlString As String = "SELECT USERID, "
    MySqlString += "SUM(case when ACTVCODE = 'POC' then 1 else 0 end) POC, "
    MySqlString += "SUM(case when ACTVCODE = 'PIC' then 1 else 0 end) PIC, "
    MySqlString += "SUM(case when ACTVCODE = 'EML' then 1 else 0 end) EML, "
    MySqlString += "SUM(case when ACTVCODE = 'AD' then 1 else 0 end) AD, "
    MySqlString += "SUM(case when RESULTCODE = 'LOG' then 1 else 0 end) LOG, "
    MySqlString += "SUM(case when RESULTCODE = 'SR' then 1 else 0 end) SR, "
    MySqlString += "SUM(case when RESULTCODE = 'DM' then 1 else 0 end) DM, "
    MySqlString += "SUM(case when RESULTCODE = 'GK' then 1 else 0 end) GK, "
    MySqlString += "SUM(case when RESULTCODE = 'AM' then 1 else 0 end) AM, "
    MySqlString += "SUM(case when RESULTCODE = 'NA' then 1 else 0 end) NA, "
    MySqlString += "SUM(case when RESULTCODE = 'RO' then 1 else 0 end) RO, "
    MySqlString += "SUM(case when RESULTCODE = 'ORE' then 1 else 0 end) ORE, "
    MySqlString += "SUM(case when RESULTCODE = 'COM' then 1 else 0 end) COM, "
    MySqlString += "SUM(case when RESULTCODE = 'SMS' then 1 else 0 end) SMS, "
    MySqlString += "SUM(case when RESULTCODE = 'SV' then 1 else 0 end) SV, "
    MySqlString += "SUM(case when RESULTCODE = 'QUO' then 1 else 0 end) QUO, "
    MySqlString += "SUM(case when RESULTCODE = 'PQU' then 1 else 0 end) PQU "

Data

I am trying to add a column at the end that will sum up each row. I tried using SUM(POC + PIC + EML + AD + LOG) but that did not work the way I thought it would. Any suggestions?

Upvotes: 0

Views: 113

Answers (1)

Amit
Amit

Reputation: 46361

You don't need to SUM:

POC + PIC + EML + AD + LOG

Upvotes: 6

Related Questions