Post reply

STORED PROCEDURE

  • January 29, 2008 at 6:08 am

    #71073

    HI ALL,

    I WANT TO KNOW ABOUT RETRIEVING THE DATA FROM STORED PROCEDURE.

    AFTER ACCESSING IT I WANT TO SHOW IT IN THE TABLE STRUCTURE,

    IS IT POSSIBLE?

    IF YES, HOW

    HEPL ME TO SOLVE THIS PROBLEM.

    THANKS IN ADVANCE

    BYE

  • January 29, 2008 at 6:43 am

    #772828

    Please don't post in all caps. It's the online equivalent of shouting.

    Am I correct in saying you want to insert the resultset from a stored proc into a table? You can do this...

    INSERT into SomeTable (ColumnList)

    Exec SomeProc

    The columns of the table and the proc must match. The table must exist.

    Does this help?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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