Combining two Select statements with added formatting

user_3059855 0
Viewed 46

I have two Select Statements that return the correct information.

PartQnty = (Select SUM(Part_Qnty) from ClaimParts where claim_ID = Claims.Claim_ID),

and

PartCount = (Select count(parts_ID) from ClaimParts where claim_ID = Claims.Claim_ID),

I need to Combine the result of both in this format: "PartCount/PartQnty" (2/1) It needs to be in the format above before being returned to the cfgridcolumn.

coldfusion tsql
2 Answers
Related