It would be good to see an example of this as I think this would be a more practical example.

Maybe I'm missing something, but can you control access on a hierarchy basis?

This looks to me like you either only see your dept's data or everything. I'm thinking about...

Hi All,

Thanks for the responses, as per the original query I have tried the union all in comparison to the unpivot and for the first run the data takes 3...