Return First Two Numbers in Decimal Result

[larrydavid]

Hello,

I have this numerator/denominator in my SQL statement:

[Denial Ratio] = (SELECT COUNT(oc.[CLAIMNO]) FROM CLAIMS oc WHERE oc.chkamt1 = 0.00 AND oc.chkamt2 = 0.00 AND oc.chkamt3 = 0.00) * 1.0 / COUNT(oc.CLAIMNO) * 100,

The output is:

[Denial Ratio]
621147.950428979900
479811.634756995500
503932.095901005400
892581.095890410900
513058.425196850300
1054343.365695792800
1544038.388625592400

I've tried several functions (ROUND, LEFT, MATH(floor) to name a few) to round this to the first two numbers so my desired output would be:

[Denial Ratio]
62.11479504289799
47.98116347569955
50.39320959010054
89.25810958904109
51.30584251968503
10.543433656957928
15.440383886255924

I'm pulling out my last hair. If anyone can provide an example or point in the right direction I would be much obliged.

Thanks,
Larry

 

[r937]

have you ried this --

[Denial Ratio] = (SELECT COUNT(oc.[CLAIMNO]) FROM CLAIMS oc WHERE oc.chkamt1 = 0.00 AND oc.chkamt2 = 0.00 AND oc.chkamt3 = 0.00) * 1.0 / [red](SELECT COUNT(CLAIMNO) FROM CLAIMS)[/red] * 100,

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[larrydavid]

I'll try it. But what is the difference between doing a "select" count vs. a count?

 

[r937]

But what is the difference between doing a "select" count vs. a count?

i can answer that as soon as you try it and report the results


and if it doesn't work, i would want to see the entire query




r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[markros]

There is an MSDN thread on this topic

http://social.msdn.microsoft.com/Fo...1c69022/#9f49eef9-f5a9-4b39-8922-c990a2278a9f

PluralSight Learning Library