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

Draw An Arrow

Posted on

Imports System.Drawing Imports System.Drawing.Drawing2D Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub Private Sub Form1_Paint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles MyBase.Paint Dim grp As Graphics = e.Graphics Dim TempPen As New Pen(Color.Aqua, 10) TempPen.StartCap = Drawing2D.LineCap.ArrowAnchor grp.DrawLine(TempPen, 100,…

Read More

PowerShell – Windows DNS Server Basics

Posted on

# Windows Version – Helps to know what version as some things change from one version to another. (Get-WmiObject -class Win32_OperatingSystem).Caption $ZN = "kittell.net" # List DNS Forwarders – Where to go if DNS record not in this DNS server Get-DnsServerForwarder # Remove DNS Server Forwards #Remove-DnsServerForwarder -IPAddress 8.8.8.8 -PassThru…

Read More

C# – Start/Stop/Restart Services

Posted on

using System.ServiceProcess; The following method tries to start a service specified by a service name. Then it waits until the service is running or a timeout occurs. public static void StartService(string serviceName, int timeoutMilliseconds) { ServiceController service = new ServiceController(serviceName); try { TimeSpan timeout = TimeSpan.FromMilliseconds(timeoutMilliseconds); service.Start(); service.WaitForStatus(ServiceControllerStatus.Running, timeout); }…

Read More