Thanks for the reply. I tried taking it out but got the following error:

Server: Msg 8152, Level 16, State 9, Line 1

String or binary data would be truncated.

The statement has...

Ahh sweet mother of meat. Works great, thanks moose!

Thanks guys!

Both worked, though I had to fiddle with phil's query a bit, which is a good thing since I learned a lot about joins

Sorry to bump this, but first try on post was missing half the text I typed in.

Sweet! Thanks David, did exactly what I needed it to do!

Phil, sorry I wasn't more clear, these are user tables not sys, but the point is now moot. Thanks for...

As a follow up question, is it possible to save my diagram off as a file somehow? I have to include it in some documentation and not sure if there's...

Perfect. Thanks!