Recent content by athomas008

Can it done without a pivot function.

Here is the table I have - Resource ID | USR ID | USR GRP ------------------------------- resource123 | 901235 | Owner resource123 | 945678 | Manager resource123 | 967823 | Delegate resource123 | 932851 | Delegate resource123 | 867324 | Delegate resource456 | 997836 | Manager resource456 |...