Guest User

Untitled

a guest
Aug 5th, 2018
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1.  
  2.  
  3.  
  4.  
  5.  
  6. SELECT
  7. u.id as adminID,
  8. u.fullName as fullName,
  9. (
  10. select @data = ''
  11. select coalesce(@data + ',','') + CAST(p.title AS VARCHAR(50))
  12. from adminPermission p
  13. INNER JOIN adminUserPermissionAssoc a
  14. ON p.id = a.adminPermissionID
  15. WHERE a.adminUserID = adminUser.id
  16. ) as permissionGroups
  17. FROM
  18. adminUser u
  19. WHERE
  20. u.username = 'psawhney'
  21. AND u.password = 'a8eaf1d74dc182ad4f9ff4b775dae756'
Add Comment
Please, Sign In to add comment