That's correct - I'd expect 13 as the result from the sample data.

This looks like a more distilled, set based version of what I'm doing - exactly what I was...

Apologies for the confusion, Kevin - thanks for having a look! In a hurry this morning, so I sketched it out pretty fast.

I'll set up some supporting scripts for...

Late to the party, but I did come across a free utility during my own search for such a thing:

http://sqlmgmt.com/sql/Trace-Converter

Cmd line, and single file at a time (or table), but...

Just had a go at this myself, ran into some errors, thought I'd post what needed to be done for SQL 2008 R2 to hopefully help the next guy get...

Just had a go at this myself, ran into some errors, thought I'd post what needed to be done for SQL 2008 R2 to hopefully help the next guy get...