Hi Erik,

This is great!  Thanks!  I found another sample script since I posted that does the same thing, but this is neater.

Much appreciated,  Arthur

Thank you, both of you.  Both solutions offer good possibilities. 

"User", not "Username" works for me.  Using datepart() is very simple and works nicely. 

Arthur

With the trimmed down format, there are fewer topics that I find interesting, and as a result there are days when I don't visit the web site.  If I make...

Frankly I wouldn't know how to export 2 lines from 1 row of a view.  If you're willing, please let me know.

I've had other working solutions.  I'm just looking for...

Thank you all again!

I had come to the same solution as you Vladan in your last suggestion, which works well with the view.

To summarize, I needed two rows per individual...

Thank you all for your replies, and sorry it's taken me a while to get back to you (work, finding the right ex. with sensitive info, which I X'd out.)

Here...

The view you describe is what I want, but I can't denormalize, unless I do that for a temp table.

I guess I'm looking to create a pivot table.  And at this...