MSSQL – Get Percentage

Posted on By David Kittell 
SELECT [Lead Status]
	,Count([Lead Status]) AS [Lead Status Total]
	,Cast((Count([Lead Status]) * 1.00) / (
			SELECT Count([Lead Status])
			FROM [table]
			) * 100 AS DECIMAL(10, 2)) AS Percentage
FROM [table]
GROUP BY [Lead Status]
ORDER BY [Lead Status Total] DESC
Originally Posted on March 18, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL SQL

Related Posts

PowerShell – Get/Set Windows Date/Time from NTP

Posted on

Sometimes w32Time is not available or practical so we get this PowerShell script to pull NTP date/time and set the Windows Date/Time <# Majority of code is from: Chris Warwick, @cjwarwickps, August 2012 chrisjwarwick.wordpress.com #> $sNTPServer = ‘pool.ntp.org’ function Get-NTPDateTime ([string] $sNTPServer) { $StartOfEpoch=New-Object DateTime(1900,1,1,0,0,0,[DateTimeKind]::Utc) [Byte[]]$NtpData = ,0 * 48…

Read More

Mac OSX Terminal – Uninstall Palo Alto Global Protect

Posted on

First copy this text to a file and name it uninstall_gp.sh The code below is right from the Palo Alto Global Protect installer for Mac #!/bin/sh USER_ID=`id -u` if [ "$USER_ID" -ne 0 ]; then echo "You must be root to run the script. Use sudo $0" exit fi install_dir=/Applications/GlobalProtect.app/Contents/Resources…

Read More

PHP – WordPress – Blog Info

Posted on

This is a simple piece of code to provide basic information about your blog. The first lines of the code will restrict the PHP access to the command line interface (CLI) so not just anyone could/should be able to see the details. Additional Mime Types can be seen at: http://codex.wordpress.org/Function_Reference/get_allowed_mime_types…

Read More