Professional Web Applications Themes

join those two procedures stored in only one - Microsoft SQL / MS SQL Server

As I do to join those two procedures stored in only one: Alter Procedure sp400_Delvendstoque ( codprod int, qtped int, numev int, topest int ) As set nocount on insert TMP_delEstoque SELECT spid,codprod,qtped,numev,topest return ---------------------------------------------------------------------------- --- Alter Procedure sp400_insertEstoque ( codprod int, qtped int, numev int, topest int ) As set nocount on update dbo.estoqstand set es_ideal=(select es_ideal + tmp_qtatual FROM estoqstand INNER JOIN TMP_delEstoque ON es_prod = TMP_prod where tmp_prod=codprod and TMP_top=0 and tmp_evento= numev and tmp_id=spid ) FROM estoqstand INNER JOIN TMP_delEstoque ON es_prod = TMP_prod where tmp_prod=codprod and TMP_top=0 and tmp_evento= numev and tmp_id=spid delete TMP_delEstoque where ...

  1. #1

    Default join those two procedures stored in only one

    As I do to join those two procedures stored in only one:

    Alter Procedure sp400_Delvendstoque

    (
    codprod int,
    qtped int,
    numev int,
    topest int

    )

    As
    set nocount on



    insert
    TMP_delEstoque
    SELECT spid,codprod,qtped,numev,topest

    return



    ----------------------------------------------------------------------------
    ---










    Alter Procedure sp400_insertEstoque

    (
    codprod int,
    qtped int,
    numev int,
    topest int

    )

    As
    set nocount on



    update dbo.estoqstand
    set es_ideal=(select es_ideal + tmp_qtatual
    FROM estoqstand INNER JOIN
    TMP_delEstoque ON es_prod = TMP_prod
    where tmp_prod=codprod and TMP_top=0 and tmp_evento= numev and
    tmp_id=spid )
    FROM estoqstand INNER JOIN
    TMP_delEstoque ON es_prod = TMP_prod
    where tmp_prod=codprod and TMP_top=0 and tmp_evento= numev and
    tmp_id=spid

    delete TMP_delEstoque
    where tmp_id=spid


    return


    Frank Guest

  2. #2

    Default Re: join those two procedures stored in only one

    Please can you post DDL (CREATE TABLE statements) and sample data (INSERT
    statements).

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Frank Dulk" <com.br> wrote in message
    news:phx.gbl... 
    -- 


    David Guest

  3. #3

    Default Re: join those two procedures stored in only one

    They are already posted.


    "David Portas" <org> escreveu na mensagem
    news:phx.gbl... 
    >
    > --------------------------------------------------------------------------
    > -- 
    >
    >[/ref]


    Frank Guest

  4. #4

    Default Re: join those two procedures stored in only one

    > They are already posted.

    You didn't post CREATE TABLE statements for your tables (unless there was an
    attachment that got lost) or any sample data.

    The DDL at least is needed because it's not clear in your UPDATE query which
    column belongs to which table.

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --



    David Guest

Similar Threads

  1. Stored Procedures
    By Anthony M. Davis in forum Coldfusion - Advanced Techniques
    Replies: 28
    Last Post: February 9th, 03:17 PM
  2. dt_ Stored Procedures
    By chopper in forum ASP Database
    Replies: 2
    Last Post: July 20th, 04:06 PM
  3. New to ASP and Stored Procedures
    By John Berman in forum ASP Database
    Replies: 6
    Last Post: February 28th, 01:37 AM
  4. Stored Procedures and 4GL
    By Ahmer Sajjad in forum Informix
    Replies: 1
    Last Post: September 9th, 01:23 PM
  5. Need help about stored procedures
    By Tahir in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 23rd, 10:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139