Professional Web Applications Themes

Dynamic columns creation - Microsoft SQL / MS SQL Server

Hi. I have a stored procedure that among other things returns a column with values that will be used to compose a temporary table. The number of records returned by the procedure can vary and I need to read the values of this specific column and use them as column names in my temporary table. I read some articles about dynamic sql but could not find anything similar to what I need. Is it possible? Thanks, Antonio Maciel...

  1. #1

    Default Dynamic columns creation

    Hi.

    I have a stored procedure that among other things returns a column with
    values that will be used to compose a temporary table. The number of records
    returned by the procedure can vary and I need to read the values of this
    specific column and use them as column names in my temporary table. I read
    some articles about dynamic sql but could not find anything similar to what
    I need. Is it possible?

    Thanks,

    Antonio Maciel


    Antonio Maciel Guest

  2. #2

    Default Re: Dynamic columns creation

    Antonio Maciel (antmacconsys.com) writes:
    > I have a stored procedure that among other things returns a column with
    > values that will be used to compose a temporary table. The number of
    > records returned by the procedure can vary and I need to read the values
    > of this specific column and use them as column names in my temporary
    > table. I read some articles about dynamic sql but could not find
    > anything similar to what I need. Is it possible?
    Possible? Probably. Painlessly? No. I would suggest that you take one
    step at the scenario. Whatever you are involved in, it sounds like it's
    redesign time.

    Maybe you could give more details on what business problem you are really
    trying to address?

    --
    Erland Sommarskog, SQL Server MVP, [email]sommaralgonet.se[/email]

    Books Online for SQL Server SP3 at
    [url]http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/url]
    Erland Sommarskog Guest

Similar Threads

  1. dynamic xml creation
    By mixey18 in forum Macromedia Flash Data Integration
    Replies: 3
    Last Post: December 13th, 07:01 PM
  2. Creation and Positioning DataGrid Columns at runtime.
    By Alan Seunarayan in forum ASP.NET Data Grid Control
    Replies: 5
    Last Post: July 27th, 12:59 PM
  3. dynamic tag creation
    By JJBBDD in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: July 14th, 08:43 PM
  4. Dynamic content creation
    By demboos in forum Macromedia Flex General Discussion
    Replies: 4
    Last Post: February 18th, 07:12 PM
  5. Dynamic Sprite Creation
    By Ten in forum Macromedia Director Basics
    Replies: 3
    Last Post: September 17th, 09:28 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