Output of SP1 stored procedure in #Temp TABLE OF SP2.

[Question123]

Hello ..

I want Output of SP1 stored procedure in #Temp TABLE OF SP2.

Something like this .......

CREATE SP2
@iLoginId INT
AS
BEGIN

SELECT *
INTO #Temp
FROM [SP1]

SELECT TOP 20
FROM #Temp

END

--Regards

[ck9663]

If you create the temp table inside your stored proc, it will not be visible outside that stored proc.

There might be other ways of doing it. What are you trying to do?

-- CK

[Question123]

If you create the temp table inside your stored proc, it will not be visible outside that stored proc.

There might be other ways of doing it. What are you trying to do?

-- CK

Hello

i am trying to SELECT TOP 10 recordes of output of SP1 from SP2.

-- Regards

[ck9663]

Try using a table function.

-- CK

[Question123]

Try using a table function.

-- CK

Hello

Thanks for the reply.

With Table function problem is that i have to know table schema before creating table function.

But i am executing any sp [SP1 is name of stored procedure passed to SP2] so i dont know table schema.

so give me any idea..

--Regards,

[ck9663]

Could you oist some sample data and what you're trying to accomplish?

-- CK