Post reply

Passing Select statement result to SP

  • April 7, 2005 at 10:18 am

    #88706

    Hi Friends,

    What i want to know is .. i have a sp

    F_Tes @TXNID,@NOMINALACC,NULL,NULL,@TXNDATE,@MNTLYAMT,@DETAILS,NULL,@LINEID OUTPUT,@TRACKERID

    i want know whether the following sql is possible or not

    EXEC F_INSERT_NL_JOURNALENTRYDEBITLINE @TXNID,@NOMINALACC,NULL,NULL,@TXNDATE,@MNTLYAMT,@DETAILS,NULL,@LINEID OUTPUT,@TRACKERID

    SELECT 1 as TXNID,A.NOMINALACC,NULL a,NULL,CAST(GETDATE()  AS VARCHAR(12)),PITEM.GROSSCOST,'AUTO GENERATED ACCRUAL FOR PO ITEM ' + RIGHT('000000000' + CAST(PITEM.ORDERITEMID AS VARCHAR),7),

         NULL,2

         FROM NL_ACCRUALS A

         INNER JOIN NL_YEARENDACCRAL Y ON A.ACCRUALID=Y.ACCRUALID

         INNER JOIN F_PURCHASEITEM PITEM ON Y.POORDERITEMITD=PITEM.ORDERITEMID

         WHERE A.ACCRUALID=1

    Just like

    INSERT INTO TABLE1 SELECT COULMN FROM TABLE2

    vINU

     

     

  • April 7, 2005 at 11:47 pm

    #551357

    Hmm if your question is: Can I execute a stored proc for each result row in a select statement? the answer is No. You have to use a Cursor, or some other method to exec the sproc in a loop, passing it new variables each time.

    If your question is: Can I insert the results of a stored proc into a table? the answer is yes. INSERT INTO Table1 (col1, col2) EXEC Sproc1 @var1, @var2

     

    Julian Kuiters
    juliankuiters.id.au

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

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