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.

All of the data for your project has been inserted with the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!