Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Name: CREATE PROCEDURE proc_TerritoryTop5Sales_ByProduct
- a. Parameter: Territory Name
- (Passing Value)
- b. Results set: Top 5 Products by year
- (The following is for the results set, which will be created in your statement in order to
- pass in Territory Name to receive the Top 5 Products sold (Sum of Line Total) by
- each Year)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement