Select case + count + 2 consultas

[estlui]

Buenas noches...

Me podrian ayudar con esta consulta:

Código SQL:

SELECT  CASE  WHEN COUNT(*) = 0 THEN
 
(SELECT     'Forecast:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0' 
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13
                      UNION ALL
                      SELECT     'PRQs:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0' 
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13
UNION ALL
SELECT     'Saldo:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0' 
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13)
 
ELSE
 
(SELECT     'Forecast:' AS Expr1, enero, febrero, marzo, abril, mayo, junio, julio, agosto, septiembre, octubre, noviembre, diciembre
FROM         [tbl_forecast ]
WHERE     (cuenta = 2000) AND (departamento = 65013) AND (anio = 2013)
UNION ALL
SELECT     'PRQs:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0' 
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13
UNION ALL
SELECT     'Saldo:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0' 
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13)
                      
END
FROM         [tbl_forecast ]
WHERE     (cuenta = 2000) AND (departamento = 65011) AND (anio = 2013)
 

Lo que necesito es: Si Count es = 0 entonces que ejecute una consulta.... si es igual a 1 entonces que ejecute la otra consulta....

Lo que tengo me manda un error, dice:

Msg 116, Level 16, State 1, Line 13
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
Msg 116, Level 16, State 1, Line 25
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

¿que me falta o que me sobra?

Mcuhas gracias

[Libras]

lo que pasa es que en un case solo puedes mostrar un valor porque no usas algo como esto

if select count(*) from tu tabla=1
begin
query1
end
else
begin
query2
end

en lugar de tratar de ponerlo en un solo case?

[estlui]

Excelente amigo Libras!, Eres un Master....

Quedo asi:

Código SQL:

IF (SELECT     COUNT(*) AS Expr1
FROM         [tbl_forecast ]
WHERE     (cuenta = 2000) AND (departamento = 65011) AND (anio = 2013)) = 1
BEGIN
SELECT     'Forecast:' AS Expr1, enero, febrero, marzo, abril, mayo, junio, julio, agosto, septiembre, octubre, noviembre, diciembre
FROM         [tbl_forecast ]
WHERE     (cuenta = 2000) AND (departamento = 65011) AND (anio = 2013)
UNION ALL
SELECT     'PRQs:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0'
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13
UNION ALL
SELECT     'Saldo:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0'
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13
FROM         [tbl_forecast ]
WHERE     (cuenta = 2000) AND (departamento = 65013) AND (anio = 2013)
END
ELSE
BEGIN
SELECT
'Forecast:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0'
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13
                      UNION ALL
                      SELECT     'PRQs:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0'
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13
UNION ALL
SELECT     'Saldo:' AS Expr1, '0' AS Expr2, '0' AS Expr3, '0' AS Expr4, '0' AS Expr5, '0' AS Expr6, '0' AS Expr7, '0' AS Expr8, '0' AS Expr9, '0'
                      AS Expr10, '0' AS Expr11, '0' AS Expr12, '0' AS Expr13
 
END
 

Muchas gracias.

PD. aun te debo las frias.... no creas que se me ha olvidado.

[Libras]

que bien que todo funciono y de las frias ps espero que las tengas en el refri para que esten bien muertas jajajaja ;)

saludos!