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