question

aRookieBIdev avatar image
aRookieBIdev asked

ROW Filtering for User

Hi Everyone,

I have a requirement to filter the data based on the user's level of access. Following is an example of how the table is structured

Expected Result

I have tried to implement this in join . I tried to exclude the joining the column if it has a value 'ALL' through a case statement. I am looking for your suggestions to do this better. Thank you in advance

sql-server-2012userrow
tables.png (17.1 KiB)
expectedresult.png (31.4 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.