Professional Web Applications Themes

Using a SP inside another SP - Microsoft SQL / MS SQL Server

You'll have to use some sort of SELECT statement for the CURSOR declaration. You could change MissingSheets from a procedure to a table function, then change the the CURSOR declaration to call the function: DECLARE MissingSheets CURSOR FOR SELECT * FROM GetNullTimeSheets(AssigneeID) I hope this helps. Good luck!   syntax is  the second SP ...

  1. #1

    Default Using a SP inside another SP

    You'll have to use some sort of SELECT statement for the
    CURSOR declaration. You could change MissingSheets from a
    procedure to a table function, then change the the CURSOR
    declaration to call the function:

    DECLARE MissingSheets CURSOR FOR
    SELECT * FROM GetNullTimeSheets(AssigneeID)

    I hope this helps. Good luck!
     
    syntax is 
    the second SP 

    AngelWPB Guest

  2. #2

    Default Using a SP inside another SP

    You have to use a SELECT for CURSOR declaration. You could
    change GetNullTimeSheets from a procedure to a table
    function, the change the CURSOR declaration to call the
    function:

    DECLARE MissingSheets CURSOR FOR
    SELECT * FROM GetNullTimeSheets(AssigneeID)

    I hope this helps. Good luck!

    --Angel
    --------------------------------
    Every time I lose my mind,
    I wonder if it's really worth finding.

     
    syntax is 
    the second SP 
    AngelWPB Guest

  3. #3

    Default Re: Using a SP inside another SP

    Angel,

    The syntax you provided does not appear to be correct. I have tried in both
    SQL 7 and 2000

    Thanks,
    Dan

    The syntax you supplied does not appear to work for
    "AngelWPB" <com> wrote in message
    news:0b9201c35846$255c8040$gbl... 
    > syntax is 
    > the second SP [/ref]


    solex Guest

  4. #4

    Default Re: Using a SP inside another SP

    Have you changed the GetNullTimeSheets procedure into a
    function that returns a table? If not, post the code for
    it and we can help.

    Then in Query yzer, try calling the function in a
    SELECT statement, passing it a valid AssigneeID:
    SELECT * FROM GetNullTimeSheets(12345)

    Only after these two steps are successful will you be able
    to use the function in the SELECT for the CURSOR
    declaration.

    --Angel
     
    have tried in both [/ref]
    could [/ref][/ref]
    the [/ref][/ref]
    of [/ref]
    >
    >
    >.[/ref]

    AngelWPB Guest

Similar Threads

  1. FTP from inside the browser
    By geegio in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: March 21st, 11:25 PM
  2. UDF inside CFQuery?
    By Monizzle in forum Coldfusion Database Access
    Replies: 3
    Last Post: March 3rd, 01:28 PM
  3. Resizing a swf inside a swf
    By John Smith in forum Macromedia Flash
    Replies: 1
    Last Post: June 7th, 12:01 AM
  4. Replies: 1
    Last Post: March 1st, 11:48 PM
  5. Texturing inside and out
    By W. Locke Morgan in forum Macromedia Director 3D
    Replies: 0
    Last Post: September 13th, 09:07 PM

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