Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    1

    Unanswered: pivot on dynamic columns

    I have a table with 40k terms and I need to map these to a set of objects where each object is represented as a column(tinyint). The object/column name is represented as a guid and columns are added/removed dynamically to support new objects for a set of terms.

    I can get the rows needed:

    guid1 guid2 guid3 guid4 guid5
    ================================
    0 1 1 0 0
    0 1 1 0 1

    I think I need to then convert this set of rows to a table which I can join to the object runtime table to start these objects if the column has a count/sum greater than 0. This is the table I think I need in order to join on guids to the runtime table:

    NAME Count
    ===========
    guid1 0
    guid2 2
    guid3 2
    guid4 0
    guid5 1

    I don't know how to construct this table for the former table. I think it may be a pivot table, but I don't know. I have the column names:

    SELECT NAME
    FROM SYSCOLUMNS
    WHERE ID = OBJECT_ID(#Temp)
    ORDER BY COLID

    NAME is a sysname, which doesn't seem to cast into a guid, also a problem when joining the runtime table with this #Temp table.

    I also don't want to use a cursor to construct a table.


    Thanks for any help,
    James

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

Posting Permissions

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