Sum using Case statement in SQL Server

AbdulHaq...

SOLVED CLOSED ACTIVE ANSWERED
User: AbdulHaque
Posted: on Feb 08, 2018 01:03 AM
Forum: SQL Server
Answer: 1
Views: 3638

Hello,

I am trying to sum values of two different database tables using join operation but after that I am getting a wrong sum value.

Ex: db1.tbl1.sum = 20 and db2.tbl1.sum = 40 then sum = 60

but i am getting wrong sum = 1024312

below is my code kindly correct me

select sum(case when w.Status_Type !=4 then 1 else 0 end) +  sum(case when m.Status_Type !=4 then 1 else 0 end) as total 
from hkrdb.dbo.works w right join Macro.dbo.works m on w.DIST_code = m.DIST_code  where w.DIST_code = 1

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Feb 08, 2018 02:22 AM
Report

Hi AbdulHaque,

I have checked the query is write. You need to check the record in your database.

Check the below sample query.

SQL

SELECT * FROM [Sample].[dbo].[Customers]
SELECT * FROM [Test].[dbo].[Customers]

SELECT sum(case when w.Country !='India' then 1 else 0 end) +  sum(case when m.Country !='India' then 1 else 0 end) as total
FROM [Sample].[dbo].[Customers] w
right join [Test].[dbo].[Customers] m
on w.CustomerId = m.CustomerId

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Sum using Case statement in SQL Server

Company

Explore

Follow us

Contact Us