Post reply

Using Stored Procedure to populate Temporary Table

  • June 14, 2010 at 6:33 am

    #387149

    Hi,

    I would like to use one of the already existing Stored procedure logic to populate current procedure's temporary table just to make use of the existing logic.

    Problem here is that, the existing SP returns two result sets as below.

    Result Set 1: Count of the records

    Result Set 2: Actual record set rows that matches the count returned in the result set 1.

    How ever, I would like to capture only the first result set (Count of the records) into the temp table of currently developing SP. Based on my testing, I found that we can not use an SP returning more than one result set to populate temp table(INSERT-EXECUTE).

    Is there any solution to achieve this?

    Thanks in advance,

    Suresh

    Regards,
    Suresh Arumugam

  • June 14, 2010 at 7:31 am

    #1179850

    Hi Suresh,

    Can you please check the tutorial named How to SQL Select from Stored Procedure using SQL Server OPENQUERY or OPENROWSET

    When I use a code like below

    SELECT *

    into #t

    FROM OPENQUERY([.], 'MySQLSamples.dbo.GetDBObjects') query

    where the GetDBObjects proc returns more than one result sets, only the first result set is used for populating temp table.

    Perhaps you can use this structure.

    I hope that helps,

    Eralper

    Eralper
    SQL Server and T-SQL Tutorials and Articles
    Microsoft Certification and Certification Exams

  • June 14, 2010 at 9:13 am

    #1179938

    Thanks a lot EralPer! I will try them out.

    Regards,
    Suresh Arumugam

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply