get count of all values of a variable in sql

Asked Mar 13 '20 at 09:24

Active Mar 13 '20 at 09:24

Viewed 30 times

i have a variable named "status" in which there are values like : Expired No Interest Already Engaged Never Reached Non-Supported Market Nurture

i want to get count of all these.

do i have to write manually like :

select 
sum (case when a.[Status Reason] ='Expired' and a.status='Disqualififed' then 1 else 0 end ) as expired,
sum (case when a.[Status Reason] ='No interest' and a.status='Disqualififed' then 1 else 0 end ) as nointerst from lead

is there any shortcut or some kind of automation possible

asked Mar 13 '20 at 09:24

Adi

Are you asking how to do a [Dynamic Pivot](https://stackoverflow.com/q/10404348/2029983)? – Thom A Mar 13 '20 at 09:27
yes doing it dynamically without write sql for every value – Adi Mar 13 '20 at 09:33
Then the link should be all you need. :) – Thom A Mar 13 '20 at 09:36

get count of all values of a variable in sql

0 Answers0

Linked

Related