Question: All of the data for your project has been inserted with the exception of the shippingMethods table. Your task is to create a new stored
All of the data for your project has been inserted with the exception of the shippingMethods table. Your task is to create a new stored procedure called Insert_ShippingMethod_Data and write the necessary code to insert the shipping method data into your tables. Once you create the stored procedure, you must execute the stored procedure in order to populate the shippingMethods table. The data to be inserted into your table is below.

shippingMethods vRatebaseWeight 0.5 0.5 fRate shipIDcompany method 101 102 103 104 201 202 203 204 301 302 303 20 10 10 10 15 15 15 15 20 10 10 Standard Ground 10 Standard Air Express Air Next Day Air Fedex 20 30 40 Fedex Fedex Fedex UPS UPS UPS UPS USPS USPS USPS USPS Standard Ground 15 Standard Air Express Air Next Day Air Standard Ground 5 Standard Air Express Air Next Day Air 0.5 0.5 0.5 0.5 0.5 0.5 25 35 45 15 30 40 10 304
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
