Results 1 to 3 of 3

Thread: variable variables

  1. 10-14-2004, 09:04 AM #1
    RathE
    RathE is offline Registered User
    Join Date
    Sep 2004
    Posts
    34

    variable variables

    Is there any way in SQL to create a variable amount of variables, or more importantly, a variable number of columns.
    Reply With Quote Reply With Quote
  2. 10-18-2004, 10:48 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    SQL Server (or any DBMS) does not support variable number of columns.

    Why do you need variable number of columns in a table?.

    You can store variable column data in rows and pivot the table to get results later.
    Reply With Quote Reply With Quote
  3. 10-19-2004, 01:39 AM #3
    RathE
    RathE is offline Registered User
    Join Date
    Sep 2004
    Posts
    34
    This in order to convert rows into columns, and although I can do it with a set number of rows, I need to be able to do it with any number of rows (obivously not exceeding the 255 or 256 column limit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules