Using EXEC with INSERT INTO

[prandip]

I am having problems inserting into a table from tuples returned through exec. Here's an example of the code:

INSERT INTO EXEC

e.g. INSERT INTO #temptbl EXEC tempproc

I get the error:
Incorrect syntax near the keyword EXEC

Kindly advice

[Yogeeraj_1]

hi,

the correct syntax would be:

insert into select ...

hope this helps!

yogeeraj

[prandip]

Hi Yogeeraj,
Thanks again but i am aware of that. I want to use values returned from a stored procedure, hence my problem. Again SQL Server allows using EXEC after INSERT INTO. Sybase is again giving me a no-no. Kindly advice on a work around on the syntax if there exists one.

Revert

Prandip

[Remigiusz_1]

HI!

If stored procedyre return one value:

declare @return int
exec @return =
insert into values(@return)

when stored procedure return more than one values you must define procedure to set values of its parameters

delcare @ret1 int, @ret2 int
exec @ret1 output, @ret2 output
insert into values (@ret1, @ret2)

:-) ..
on MS SQL Server should work
... sory my english !!

[Remigiusz_1]

HI!

If stored procedyre return one value:

declare @return int
exec @return =
insert into values(@return)

when stored procedure return more than one values you must define procedure to set values of its parameters

delcare @ret1 int, @ret2 int
exec @ret1 output, @ret2 output
insert into values (@ret1, @ret2)

:-) ..
on MS SQL Server should work
... sory my english !!

[Remigiusz_1]

HI!

If stored procedyre return one value:

declare @return int
exec @return =
insert into values(@return)

when stored procedure return more than one values you must define procedure to set values of its parameters

delcare @ret1 int, @ret2 int
exec @ret1 output, @ret2 output
insert into values (@ret1, @ret2)

:-) ..
on MS SQL Server should work
... sory my english !!

[prandip]

Thanks mate!! No problem on english i assure you. I guess this will suffice for me now. Thanks again!!