The case expression evaluates row by row the value of the column t and then gets into the appropriate "then". When the row containing "O" is evaluated, the expression returns...

Much better than mine.

Try adding a computed column in a subquery and then order by that column:

declare @t table (t varchar(5))

insert into @t values('F')

insert into @t values('A')

insert into @t values('O')

insert into @t values('L')

insert...

LOL! What's your hourly fee, Wayne? I need to get the grass cut... 😀

I use HitOLEDB400 from Hit Software and it performs quite well.

With "quite well" I mean we can transfer 2 Gb of data from iSeries to SQLServer in less than...

... but, wait: wasn't PBAP "Porkchop By Agonizing Porkchop"? 😀

I was keeping this for the day Microsoft decides to...

What about piping the sp result set into a temp table and the selecting just the columns you need?

Something like:

CREATE TABLE #tempTable (column1 int, ... columnN int)

INSERT #tempTable EXEC myProcedure

SELECT...

I'm sorry, there's no way to get it with a PIVOT operation, because column names have to be explicitly defined.

I'm just wondering why you need to get data that way:...

The instance can have any name you like. I'm not aware of any issue with choosing a custom name.

Hope this helps

Gianluca

I must believe you're not referring to this article, or I misunderstood your post.

I think the community...

It works, but it is quite useless if you want to pivot for a dynamic column list....

Glad I could help

...maybe as I suggested in my previous post?

Or are you suggesting a different strategy?

Obviously you would have to add a new column to the trace table ad add the code to populate it in the db trigger.

You can get the application name from the connection properties:

select program_name from master.dbo.sysprocesses where spid = @@spid

But I don't know if this is exactly what you need.