That worked well for children, but grandchildren are left as null.

Is there an elegant way to get the info from the parents parent when the parent is null also? For...

insert #MyResult

select 'TC30001','','1','2','2','3','' UNION ALL

select 'TC30001B','TC30001','1','2','','',''

select * from #mytable where lotid = 'TC30001' or parent = 'TC30001'

select * from #MyResult where lotid = 'TC30001' or parent =...

Order of how a lot can travel through the tools?

Left to right: VBS ... TCO

Maybe I don't understand the question.

Tim

Also,

I was using Firefox 14.01 while trying to post a code block...

Using IE 8 seems to work just fine.

Select * from test

Sean,

First, I would like to thank you for taking the time to answer my post.

I have attached expected output in an excel spreadsheet. In the expected tab, I have the...

Pretty sure that the Pivot expects to do the aggregate function on the data regardless of what it is.

PIVOT ( sum(VariableValue) FOR VariableName IN ( ' + @COLS + ')...

So I figured it out, thanks to your example. I altered the original table slightly.

CREATE TABLE [dbo].[Normalized](

[TimeStamp] [datetime] NOT NULL,

[LotID] [nvarchar](18) NOT NULL,

[VariableName] [nvarchar](12) NULL,

[VariableValue] [nvarchar](25) NULL,

CONSTRAINT [PK_Normalized] PRIMARY...