a guest Jul 24th, 2019 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT @Setting = COALESCE((CASE
- WHEN @capName = 'role1'
- AND .....?
- THEN 1
- ELSE 0
- END), 1)
- FROM table1 t
- WHERE t.accountId = 'nameA'
- AND t.capName IN ('role1','role2')
RAW Paste Data