Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Unanswered: Dynamic table creation

    Suppose I have a table named table1 which has a field question_Id.There are many values for this field say 100,101,102.
    Now I want to make a table with the field name 100,101,102 but the problem is that it is not fixed how many values are there for question_id.Here in this example I mentioned three(100,101,102) but it may be anything.How can I make a table with the field names this way?
    Subhasish

  2. #2
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    11

    Re: Dynamic table creation

    Originally posted by subhasishray
    Suppose I have a table named table1 which has a field question_Id.There are many values for this field say 100,101,102.
    Now I want to make a table with the field name 100,101,102 but the problem is that it is not fixed how many values are there for question_id.Here in this example I mentioned three(100,101,102) but it may be anything.How can I make a table with the field names this way?
    Subhasish
    Why do you want to do this?
    Looks like you're after some kind of crosstab report, right?

  3. #3
    Join Date
    Oct 2003
    Posts
    83
    Yes Frank I need that.How to do?

  4. #4
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    11
    Two of the better solutions to this can be found here
    http://www.winnetmag.com/SQLServer/A...608/15608.html
    or
    http://www.sqlteam.com/item.asp?ItemID=2955

    Btw, personally I think this thing should strictly be done at the client as this is more of data presentation.

    HTH

Posting Permissions

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