Stored Procedure en CASE
Publicado por Efren Garcia (50 intervenciones) el 01/04/2008 20:59:04
porque no se puede ejecutar un SP en un CASE???
SELECT CASE ( 5 )
WHEN '1' THEN (EXEC SP_1)
WHEN '5' THEN (EXEC SP_2)
ELSE (EXECUTE SP_3)
END
FROM DB1.dbo.Tabla1 where statusE = 0
ERROR:
Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'EXEC'.
SELECT CASE ( 5 )
WHEN '1' THEN (EXEC SP_1)
WHEN '5' THEN (EXEC SP_2)
ELSE (EXECUTE SP_3)
END
FROM DB1.dbo.Tabla1 where statusE = 0
ERROR:
Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'EXEC'.
Valora esta pregunta
0