Home Forums SQL Server 2008 T-SQL (SS2K8) Unpivot question, struggling with data please help RE: Unpivot question, struggling with data please help

  • Celko- thanks for the response.

    Archaic is right on the money.

    Your guess is right on about the structure. I was wrong it's actually nvarchar(30) instead of bit. Holding "True" and "False" data and the int columns are an ID. (but no foreign key constraint... of course)

    [record_id] [int] IDENTITY(1,1) NOT NULL,

    [Column1a] [int] NULL,

    [Column2a] [nvarchar](30) NULL,

    [Column3a] [nvarchar](30) NULL,

    [Column4a] [nvarchar](30) NULL,

    [Column1b] [int] NULL,

    [Column2b] [nvarchar](30) NULL,

    [Column3b] [nvarchar](30) NULL,

    [Column4b] [nvarchar](30) NULL,