Query Question

#1

Is it possibe to combine the results of these 2 queries into a single
result set consisting of 1 row and 2 columns (for each value)?

SELECT COUNT(*) AS 'SlnCount' FROM Request WHERE RequestTypeID = 2
SELECT COUNT(*) AS 'NewSlnCount' FROM Request WHERE RequestTypeID = 2
AND StatusID = 1

#2

On Jan 22, 9:49 am, wackyph... (AT) yahoo (DOT) com wrote:

Quote:

Is it possibe to combine the results of these 2 queries into a single
result set consisting of 1 row and 2 columns (for each value)?

SELECT COUNT(*) AS 'SlnCount' FROM Request WHERE RequestTypeID = 2
SELECT COUNT(*) AS 'NewSlnCount' FROM Request WHERE RequestTypeID = 2
AND StatusID = 1

SELECT COUNT(*) AS 'SlnCount',
SUM(CASE WHEN StatusID = 1 THEN 1 ELSE 0 END) AS 'NewSlnCount'
FROM Request
WHERE RequestTypeID = 2

#3

I think you may be on to it. But I get NULL for 'NewSlnCount'. Why
would SUM report NULL?

#4

Nevermind I got it working thanks to your example.

Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query Question

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Query Question - 01-22-2008 , 08:49 AM

Re: Query Question - 01-22-2008 , 10:46 AM

Re: Query Question - 01-22-2008 , 11:21 AM

Re: Query Question - 01-22-2008 , 12:39 PM