Advertisement
Gesh4o

Untitled

Oct 13th, 2016
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. CREATE PROCEDURE usp_GetHoldersWithBalanceHigherThan(@amount MONEY)
  2. AS
  3. BEGIN
  4. SELECT FirstName, LastName FROM AccountHolders AS ac
  5. LEFT JOIN Accounts AS a ON a.AccountHolderId = ac.Id
  6. GROUP BY FirstName, LastName
  7. HAVING SUM(Balance) > @amount
  8. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement