Hello, I need to do the following, But I receive an error:
CREATE PROCEDURE dbo.EJEMPLO_A AS
BEGIN
SELECT TOP 10 NAME, ID FROM SYSCOLUMNS
END
-- and Later use the one above... like this...
CREATE PROCEDURE dbo.EJEMPLO_B AS
BEGIN
DECLARE @.temp_lista TABLE (NOMBRE VARCHAR(500),
IDENT NUMERIC(5))
INSERT INTO @.temp_lista execute dbo.EJEMPLO_JULIAN
END
Pd. I just have to capture the dbo.EJEMPLO_A resulset... and I can't modify ItTable variables cannot be used in a INSERT EXEC or SELECT INTO statement.
http://support.microsoft.com/default.aspx/kb/305977
in your second sproc you can use a temp table and it should be ok. EDIT: however this sproc will do nothing because it's not returning any data, or modifying any data in any permanent tables. so why bother?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment