Professional Web Applications Themes

SP Questions... - Microsoft SQL / MS SQL Server

- Is it possible to call another stored procedure from with one? - Can you store a table (or query result set) in variable/object within an SP? - I have a few complex views that use each other as data sources, i.e. I designed one view, created a new one and used the previous view as a data source in the new one and so on. Is it possible to recreate the output of the top-level view but do it all within one stored procedure instead of four "nested" views?...

  1. #1

    Default SP Questions...

    - Is it possible to call another stored procedure from with one?

    - Can you store a table (or query result set) in variable/object within an
    SP?

    - I have a few complex views that use each other as data sources, i.e. I
    designed one view, created a new one and used the previous view as a data
    source in the new one and so on. Is it possible to recreate the output of
    the top-level view but do it all within one stored procedure instead of four
    "nested" views?


    Beza Guest

  2. #2

    Default Re: SP Questions...

    1. exec sp_name
    2. use table variables

    HTH
    Roji

    "Beza" <bezabeza.com> wrote in message
    news:Op%23ynIIQDHA.2476TK2MSFTNGP10.phx.gbl...
    > - Is it possible to call another stored procedure from with one?
    >
    > - Can you store a table (or query result set) in variable/object within an
    > SP?
    >
    > - I have a few complex views that use each other as data sources, i.e. I
    > designed one view, created a new one and used the previous view as a data
    > source in the new one and so on. Is it possible to recreate the output of
    > the top-level view but do it all within one stored procedure instead of
    four
    > "nested" views?
    >
    >

    Roji. P. Thomas Guest

Similar Threads

  1. Four questions
    By Garry Jones in forum MySQL
    Replies: 7
    Last Post: August 10th, 04:20 PM
  2. Two questions, for those who may know
    By RichA in forum Photography
    Replies: 4
    Last Post: December 9th, 04:57 AM
  3. 2 questions.
    By usegobos webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 1
    Last Post: October 5th, 07:30 PM
  4. IIS Log Questions.
    By Shawn & Jo-an Mehaffie in forum ASP.NET General
    Replies: 0
    Last Post: August 5th, 04:13 AM
  5. 2 questions :) - portal questions
    By John Weinshel in forum FileMaker
    Replies: 3
    Last Post: July 14th, 04:37 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