Using Northwind Database

Create a stored procedure named OrderCount that has an input parameter of CustomerID. It will then count number of orders for that customer. This procedure also needs to have the recompile option turned on since the results set can vary widely. This stored procedure must access the information from the Orders Qry] view. When the Customeri parameter is entered, it will select the information from the above mentioned View, and count and return the amount of orders that customer placed. (Hint:return @@ROWCOUNT) In other works, the procedure returns a count 'of the total number of orders for any particular Customer that is entered when the stored procedure is executed