Count Function - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Count Function

Author

Topic

JJ297
Aged Yak Warrior

940 Posts

Posted - 2008-10-15 : 13:50:53

How do I get all of the items listed in the db along with the new column Total for this procedure below?

SELECT count(*) as Total
FROM ClaimInfo1
WHERE CASE
When mod = 'C12' then 'ICTU'
When mod = 'I1' then 'I&E'
WHEN RIGHT(Claim, 4) BETWEEN '0000' AND '0908' THEN '01'
WHEN RIGHT(Claim, 4) BETWEEN '0909' AND '1817' THEN '02'
WHEN RIGHT(Claim, 4) BETWEEN '1818' AND '2726' THEN '03'
WHEN RIGHT(Claim, 4) BETWEEN '2727' AND '3635' THEN '04'
WHEN RIGHT(Claim, 4) BETWEEN '3636' AND '4544' THEN '05'
WHEN RIGHT(Claim, 4) BETWEEN '4545' AND '5453' THEN '06'
WHEN RIGHT(Claim, 4) BETWEEN '5454' AND '6362' THEN '07'
WHEN RIGHT(Claim, 4) BETWEEN '6363' AND '7271' THEN '08'
WHEN RIGHT(Claim, 4) BETWEEN '7272' AND '8180' THEN '09'
WHEN RIGHT(Claim, 4) BETWEEN '8181' AND '9089' THEN '10'
WHEN RIGHT(Claim, 4) BETWEEN '9090' AND '9999' THEN '11'
END = '02'
AND PmtDate BETWEEN '8/3/2008' AND '8/31/2008'

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-15 : 13:59:53

seem like what you is only this

SELECT count(*) as Total
FROM ClaimInfo1
WHERE RIGHT(Claim, 4) BETWEEN '0909' AND '1817'
AND PmtDate BETWEEN '8/3/2008' AND '8/31/2008'

i really didnt understand need of case...when in where. You could probably explain your requirement if above is not your expected query.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources