troubleshooting Question

Syntax for Setting a Variable to Sum of Column

Avatar of Nathan Riley
Nathan RileyFlag for United States of America asked on
Microsoft SQL ServerMicrosoft DevelopmentSQL
4 Comments1 Solution270 ViewsLast Modified:
Ok, so I have a table named Customer_Juros has a column named Doctype, InvoiceNo and a column Amount that I want information out of.  How it works is there are 8 Doctype's:
1=invoice
2=cashpayment
3=insurance
ect...
In the Amount column are the corresponding amounts.

I want to set a variable:

set @DetailBalance = sum of the Amounts where the doctypes are 1's for Invoice #20545

is that possible or another way to do this?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros