Mathmatically dividing two queries

[pdbowling]

I guess this is a 2 part question.

Can you divide two scalar queries by one another?

This obviously does not do it.

SELECT COUNT(*)
  FROM myTable
 WHERE myFlag=1 /
SELECT COUNT(*)
  FROM myTable

Secondly, what would be a good method of getting the percentage of flagged records if the division is just bad form?

I am using SQL Server 2008 Management Studio.


Thank you.
Patrick

 

[bborissov]

SELECT SUM(CASE WHEN myFlag=1 THEN 1 ELSE 0 END) / COUNT(*)
FROM MyTable

Borislav Borissov
VFP9 SP2, SQL Server

 

[drlex]

[...]getting the percentage [...]

SELECT SUM(CASE WHEN myFlag=1 THEN 1 ELSE 0 END)[red][b]*1.0[/b][/red] / COUNT(*)
FROM MyTable

soi là, soi carré

 

[bborissov]

Oops

Borislav Borissov
VFP9 SP2, SQL Server