Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE usp_GetHoldersWithBalanceHigherThan(@TargetBalance MONEY)
- AS
- BEGIN
- SELECT a.FirstName AS 'First Name', a.LastName AS 'Last Name' FROM AccountHolders AS a
- INNER JOIN Accounts AS ac
- ON a.Id = ac.AccountHolderId
- GROUP BY a.FirstName, a.LastName
- HAVING SUM(ac.Balance) > @TargetBalance
- END
Add Comment
Please, Sign In to add comment