Steve, if you come anywhere near Detroit, let me know... I gotta meet you some day and it's not likely I'll make it out to your farm!

And congrats on making...

PLEASE don't double post anymore... spreads resources too thin.

http://www.sqlservercentral.com/Forums/Topic436548-146-1.aspx

PLEASE don't double post anymore... spreads resources too thin.

http://www.sqlservercentral.com/Forums/Topic436564-5-1.aspx

Please don't double post... spreads resources too thin.

http://www.sqlservercentral.com/Forums/Topic436885-146-1.aspx

Here's a slightly better rendition based on what you just posted...

Should be good for about 132 columns of RunStatuses not including Feature.

DROP TABLE Raw

GO

CREATE TABLE Raw (TestListID INT, Feature VARCHAR(256),...

...and, you're saying this didn't work?

CREATE TABLE Raw (TestListID INT, Feature VARCHAR(256), RunStatus VARCHAR(64),

...

Are you saying that you'd rather have the run status in columns instead of rows?

In other words, each row would be a Feature and each column would be a RunStatus...

... and are you saying that the query you posted is returning the data you want in the format you want it in?

I can help on the Pivot... but your real performance problem may be the view. If you do a SELECT TOP 10 from the view, how long does it...

Understood about the security thing... lemme see what I can dig up for an example...

Heh... my concern is that UDF's of this nature qualify as RBAR... you get to split exactly one row. That's fine for a single parameter passed in from a...

Microsoft still uses lightbulbs? 😛 I heard they couldn't find anyone who still knew how, so they've shifted to HI-LEDs that never need changing.

Heh... no, not what we're looking at in Word... Yes, I understand the control character notation for things like ^m (ASCII 13 or Hex OD)... Word seems to have it's...

Better than that, post the first 100 rows of your problem file as an attachment and we'll take a crack at it tonight. Also, post what the CREATE TABLE...

Yep... could be... if they're not "Fire...