Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    33

    Angry Unanswered: Build Dynamic Table Columns Issue

    How I can build a dynamic temp table based upon the dynamic coulmn info from the other table? Please see my attached file as an example. Thanks!

    J827
    Attached Thumbnails Attached Thumbnails DynamicTable.jpg  
    Last edited by jqiu827; 06-04-04 at 12:47.

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    use a hughe varchar variable and fill it with a create table statement. To determine which columnnames, try information_schema.tables. Then execute it using exec.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Mar 2004
    Posts
    33

    Thumbs up Thanks!

    Brett,

    Thanks for the Link and it works for my case.

    J827

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Hey, thank Rob Volk...he's the author...

    I'm just the messenger...

    Lots of good articles over there....

    Good Luck
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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