Returning two counters (*) results in one selection

Question

I have a stored procedure and I want it to return the following ...

TotalItems  |  FailedItems
@totalItems | @failedItems

where --> @totalItems = `SELECT COUNT(*)
    From dbo.OdsBuild AS P 
    where P.StartTime Between @StartDate and @EndDate 
    AND P.Official = 1`

where --> @failedItems = `SELECT COUNT(*)
    From dbo.Items AS P
    where p.StartTime Between @StartDate and @EndDate 
    AND P.Official = 1 AND ( P.Result = 7 OR P.Result = 8 OR P.Result = 14)`

Answer 1

Subquery SELECT COUNTs

SELECT
    (SELECT COUNT(*)
        From dbo.OdsBuild AS P 
        where P.StartTime Between @StartDate and @EndDate 
        AND P.Official = 1) totalItems ,
    (SELECT COUNT(*)
        From dbo.Items AS P
        where p.StartTime Between @StartDate and @EndDate 
        AND P.Official = 1 AND ( P.Result = 7 OR P.Result = 8 OR P.Result = 14)) failedItems

If you have already set them as variables, of course, you do not need to repeat SELECT COUNT.

SELECT @totalItems AS totalItems, @failedItems AS failedItems

SELECT statements allow autonomously without FROM clauses.

Answer 2

Can't you just select these variables at the end of your process?

SELECT @totalitems AS TotalItems, @faileditems AS FailedItems

Answer 3

What you are looking for is GROUP BY and HAVING