Posted by wackyphill on 01/22/08 14:49

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

• Next in forum: Re: Query Question
• Prev in forum: Re: Variables in SQL-script SQL2005
• Thread view: Query Question

[Reply to this message]