SQL Server Forums - Please Help Subquiries

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

Please Help Subquiries

New Topic

Reply to Topic

Printer Friendly

Author

Topic

nvoyatzopoulos
Starting Member

Greece
7 Posts

Posted - 02/28/2013 : 07:20:55

I'm having those selects and i want to included in one !

(select acct.cmpcode,count(LCODE) from ACCT group by acct.cmpcode) as logar,
(select count(LCODE) from ACCT where ISTRN = 1 ) as log_kinoum,
(select count(ARTID) from arts ) as arthra_eggrafes,
(select count(DISTINCT custid) from arts ) as syn_pou_kinith,
(select count(DISTINCT trns.LCODE) log_pou_kinithikan from trns ,arts
where arts.artid=trns.artid and arts.cmpcode=trns.cmpcode ) as logar_pou_kinith

I want each row to start with the acct.cmpcode and then the counts for each one ! How can i DO THIS ??

THANKS !

James K
Flowing Fount of Yak Knowledge

1483 Posts

Posted - 02/28/2013 : 07:37:43

The first two can be combined like shown below. As for the rst, how is ACCT table related to arts table, if at all?

SELECT
	cmpcode,
	COUNT(LCODE) logar,
	COUNT(CASE WHEN ISNTRN = 1 THEN LCODE END) AS log_kinoum
FROM
	ACCT
GROUP BY 
	cmpcode

nvoyatzopoulos
Starting Member

Greece
7 Posts

Posted - 02/28/2013 : 07:51:40

all connected by cmpcode !

quote:
Originally posted by James K

The first two can be combined like shown below. As for the rst, how is ACCT table related to arts table, if at all?
SELECT cmpcode, COUNT(LCODE) logar, COUNT(CASE WHEN ISNTRN = 1 THEN LCODE END) AS log_kinoum FROM ACCT GROUP BY cmpcode

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.03 seconds.