im very confused in the following query...
I have two select statements..
Which produce the following results.
1st SELECT STATEMENT - 5916
2nd SELECT STATEMENT - 22630
Then if i divide the 1st statement by the 2nd statement i should get 0.246.... this is currently done via a calculator...
Which will be used as a percentage in my Reporting Services report.
But when i use TSQL to divide the 1st SELECT against the 2nd SELECT it returns a 0?
What am i Doing wrong
View Complete Post