Geeks With Blogs
AngelEyes on .Net Tips, tricks and WTFs about Asp .Net, SQL Server and the likes. September 2007 Entries
SQL Server aggregated report example
An example of how to make an aggregated report, grouping together by values: select count(*) as total , count(case WHEN others = 1 THEN 1 END) as [one url], count(case WHEN others = 2 THEN 1 END) as [two urls], count(case WHEN others = 3 THEN 1 END) as [three urls], count(case WHEN others > 3 THEN 1 END) as [all the rest] from #temp2 ......

Posted On Sunday, September 16, 2007 4:16 PM

Copyright © AngelEyes | Powered by: GeeksWithBlogs.net