Fair enough. Thanks for replying!

Thanks; great post! I did have a question about the "failures" using CROSS APPLY vs OUTER APPLY though. Isn't that the expected behavior of using these functions? It seems like...

Nice article. I use APPLY quite a bit...but have never even thought to use it in this scenario. You've opened my eyes where I didn't think you could or would...very...

Good form.

Hopefully this will put a smile on Jeff's face (I'm using your TallyTable!) I love that by the way, so handy.

I used something similar to this recently...it's strange and...

Wow, thanks Peter! That works perfectly!

Now, can you help me understand it? 🙂 I hate just getting the answer...I'd like to understand it well enough that I can write my...

That seems to work well. However, what if the number of items changes? This would get the information for the first 5 (or less) items, but what if there are...

I was looking for something like this too...does anyone already have a script they could post?

Nope. You'll get database roles from that but not users or groups right? Even if it did, it wouldn't show whether a user/group had select rights but also had a...

What's the point of the User Id then? Is it needed (or referenced) for something anywhere else?

Can you bring the data into a staging table and use SQL to convert and load the final table? I find that to be a quick way to get...