StoyanGrigorov

Problem 10 Bank fail

Feb 5th, 2017
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.32 KB | None | 0 0
  1. CREATE PROCEDURE usp_GetHoldersWithBalanceHigherThan(@TargetBalance MONEY)
  2. AS
  3. BEGIN
  4.     SELECT a.FirstName AS 'First Name', a.LastName AS 'Last Name' FROM AccountHolders AS a
  5.     WHERE a.Id IN (
  6.                     SELECT AccountHolderId FROM Accounts
  7.                     GROUP BY AccountHolderId
  8.                     HAVING SUM(Balance) > @TargetBalance
  9.                   )
  10. END
Add Comment
Please, Sign In to add comment