Converting vertical database to horizontal

[mtoynbee]

Hello,

 

I have a vertical design database base as follows:

 

CREATE TABLE [dbo].[FORMENTRIES](
[ProductID] [int] NOT NULL,
[FieldUSINC] [int] NOT NULL,
[TableCol] [int] NOT NULL,
[TableRow] [int] NOT NULL,
[sTRValue] [char](254) NULL,
[iNTValue] [int] NULL,
[Language] [int] NOT NULL,
[LineNumber] [int] NOT NULL,
[DoubleValue] [float] NULL,
CONSTRAINT [PK_FORMENTRIES] PRIMARY KEY CLUSTERED 
(
[ProductID] ASC,
[FieldUSINC] ASC,
[TableCol] ASC,
[TableRow] ASC,
[Language] ASC,
[LineNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

 

I need to create a query that will display in a horizontal view using FieldUSINC as the column name and include multiple rows per item via the TableRow column.

 

Can anyone suggest some SQL code or post some links. I am using SQL Server 2000 v8.0.818 so I don't think PIVOT will be compatible.

 

Any help will be appreciated.

[mtoynbee]

*bump*