Closed. This question needs debugging details . It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem . This will help others answer the question.

Closed 9 hours ago.
Improve this question

I try to get active and inactive customers from tblcust table. I have over 82,000 inactive customers with 53,000 active ones, but both are return 53,000.

DECLARE @active int;
DECLARE @inactive int;
    
SELECT 
    @active = COUNT(*) 
FROM 
    (SELECT c.id 
     FROM tblcust c 
     WHERE c.status = 1) AS Actives;
    
SELECT 
    @inactive = COUNT(*) 
FROM 
    (SELECT * 
     FROM tblcust 
     WHERE status <> 1) AS Inactives;