You need to start by...

I don't understand the question here at all. But as posted your main procedure is going to fail because your log procedure requires 6 parameters and you have passed it...

Not a solution to the problem but one of my biggest pet peeves with queries is aliases a, b, c...I am not alone in this either. It really make debugging...

Isn't it simply this?


and t1.SessionID < t2.SessionID


You can easily extend the excellent start from Sue with something like this. I also added brackets around table and column names in case you have spaces or reserved names.

You don't need to repeat the entire query again to get the second set of values. You could do this in a single query with a second cross apply.

I suspect you are not totally comfortable with what your current code is doing. You are using FOR XML to stuff l.text and l.GUID into a single column. If you...