troubleshooting Question

Problem getting a case clause to work

Avatar of AbeSpain
AbeSpainFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerSQL
5 Comments1 Solution249 ViewsLast Modified:
I have the following code but it does nto work, I think it is something to do with the Round and sum functions inside the case clause.

      SELECT    
            Case When @JobsInvoiceVatiD = 1 then
                  Round(TPP.PartsPaidAmount,2)
            Else
                  Round(Sum(TPP.PartsPaidAmount / 1.175),2)
            end  As JobsSubTotal,            
            Round(Sum(TPP.PartsPaidAmount) - Sum(TPP.PartsPaidAmount / 1.175),2) As JobsVat,
            Sum(TPP.PartsPaidAmount) As JobsTotal
      FROM        
            tblPartsType AS TPT INNER JOIN
            tblParts AS TP ON TPT.PartsTypeiD = TP.PartsTypeiD INNER JOIN
            tblJobs AS TJ INNER JOIN
            tblPartsPayment AS TPP ON TJ.JobsiD = TPP.JobsiD ON TP.PartsiD = TPP.PartsiD INNER JOIN
            tblClients AS TC ON TJ.ClientsiD = TC.ClientsiD INNER JOIN
            tblJobsStatus AS TJS ON TJ.JobsStatusiD = TJS.JobsStatusid
      Where
            TJ.jobsid = @jobsid
ASKER CERTIFIED SOLUTION
Computer101

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
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 5 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