need a count of a column

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

I'm not clear on what you need.

Can you provide the table definition you are querying?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

hbanerje SSC Eights! Points: 818 More actions · Answer 2

Select Region, Provider, QtrName, sum(cnt_allmed) as AllMed, count(*) as [Not Reconciled in 18 months],

cast(0 as decimal (9,4)) as [% of all Meds not reconciled]---0 as [% of all Meds not reconciled]

into #over18_months_reconcilation from dbo.MRec_Gather_Med_Reconcilation_1

group by Region,Provider,QtrName

HAVING COUNT(DifferenceYrs)>0

so count of the designated col will be 11

I am not getting it. thanks.

------------------------------------------

DifferenceYrs

2

0

3

0

4

0

3

0

1

0

9

5

1

3

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

You have no table in your select...

select count(Differenceyrs)

from MyTable

group by Region,Provider,QtrName

where differenceyrs > 0

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.