Toreador (6/22/2010)
It becomes slightly more obvious if you add a 'count(*)' to the select list
Yep there's lots of variations:
SELECT 'One row', SUM(CASE WHEN 1 = 0 THEN 0 ELSE 1 END)
WHERE 1 = 0;
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi