SELECT CASE WHEN Total_Rows = Active_Rows THEN 'Valid' ELSE 'Invalid' END AS Status
FROM (
SELECT
SUM(1) AS Total_Rows,
SUM(CASE WHEN number = 'Active' THEN 1 ELSE 0 END) AS Active_Rows
FROM tbl
WHERE
number BETWEEN @firstno AND @scndno
) AS derived
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.