what is the Querry Of Percentage?

You can use the attached script for the purpose. However it is slightly tricky to use it and simple if you follow the instructions.

Copy and paste the lines between 17 to 22 into another query window, execute that query there and copy and paste the output (preferably in text format and not the grid format) at line 27.

Then execute the entire script. You can adjust the order by clause at the last line as per your requirement.

Hope it helps!

0

Pradeep Sahoo10y ago

Follow this link it may be useful http://stackoverflow.com/questions/7340266/get-count-percent-of-a-record-in-a-single-query

0

Prakash Kumar10y ago

Please refer the below links,

http://www.sqlservercentral.com/scripts/Miscellaneous/31294/

http://www.sqlserver-dba.com/2010/04/table-sizes-and-percentages.html

0

Bilawal Niaz10y ago

If i have a table "CitizenDetail",
in this table i have a 450 records, what is the querry to find percentage of 450 records,I want that querry,who show me %,That how many percent record of data in a table?

0