Advertisement
Ntubel

Untitled

Dec 12th, 2019
578
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. Name: CREATE PROCEDURE proc_TerritoryTop5Sales_ByProduct
  2. a. Parameter: Territory Name
  3. (Passing Value)
  4. b. Results set: Top 5 Products by year
  5. (The following is for the results set, which will be created in your statement in order to
  6. pass in Territory Name to receive the Top 5 Products sold (Sum of Line Total) by
  7. each Year)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement