document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. CREATE PROCEDURE [dbo].[usp_getData]
  2. @userId VARCHAR(100)
  3.  
  4. AS
  5.  
  6. SELECT     aUsers.userId, aUsers.firstName + \' \' + aUsers.lastNAme AS name, aAccounts.accountName
  7. FROM         aUsers INNER JOIN
  8.                       aUserAccounts ON aUserAccounts.userId = aUsers.userId INNER JOIN
  9.                       aAccess ON aAccess.accessLevel = aUserAccounts.accessLevel INNER JOIN
  10.                       aAccounts ON aAccounts.accountId = aUserAccounts.accountId
  11. WHERE           aUsers.userId = @userId
  12.  
  13. GO
');