SQL Server query to count

SQL Server query to count

References

Reference NO 1

http://www.w3schools.com/sql/sql_func_count.asp

Reference NO 2

http://stackoverflow.com/questions/1521605/sql-server-query-selecting-count-with-distinct

Reference NO 3

http://stackoverflow.com/questions/5381339/recursive-query-and-count-sql-server

Reference NO 4

http://dba.stackexchange.com/questions/22148/single-query-to-return-counts-over-different-ids-in-a-single-record

Reference NO 5

http://blog.sqlauthority.com/2011/03/08/sql-server-difference-between-countdistinct-vs-countall/

Reference NO 6

http://blog.sqlauthority.com/2009/08/21/sql-server-get-query-plan-along-with-query-text-and-execution-count/

Reference NO 7

http://www.sqlservercentral.com/Forums/FindPost694362.aspx

Reference NO 8

#EANF#