Re: How Do I join all this
With subqueries that return 1 value you can:
Code:
select
(inner select #1),
(inner select #2),
(inner select #3)
or in your case, something like:
Code:
select
(select count(*) from quote_request_table where convert(varchar, request_date, 103) = convert(varchar, getdate(), 103) and Status = 1) as printed,
(select count(*) from quote_request_table where convert(varchar, request_date, 103) = convert(varchar, getdate(), 103) and Status = 2) as errors,
(select count(*) from quote_request_table where convert(varchar, request_date, 103) = convert(varchar, getdate(),103) and Status = 3) as reprint,
(select count(*) from quote_request_table where convert(varchar, request_date, 103) = convert(varchar, getdate(), 103)) as totals
- petter
Re: How Do I join all this
Thanks very much. Works a treat