Untitled

Sql server temp table
IF (count(*) = 0)
    BEGIN
    PRINT 'Espace vide'
    END
    else
    Select deptno,count(*)
    from emp
    group by deptno;

Select deptno,count(*) cnt
INTO #TempTable
from emp
group by deptno;

select
  *,
  CASE cnt WHEN 0 THEN 'Espace vide' ELSE NULL END AS column1
FROM #TempTable

if exists(SELECT * FROM #TempTable WHERE cnt = 0) PRINT 'Espace vide'