databae management 2

AP management studio

2. Declare a table variable called Vendor V". In that table, insert the following data which should be generated with a query that joins the Vendors & Invoices tables with aggregate functions and group by, where county is the number of invoices of each vendor and total is the Payment Total of each vendor. Refer to lecture WK3-Ch14-scripts(2) Slide#3. Then write a select query to display the data from the VendorV table variable to look like the following table. Some numbers in the total column may not match with yours. vname countv total Federal Express Corporation 47 4167.13 United Parcel Service 23177.96 Zylka Design 6740.25 Pacific Bell 171.01 Malloy Lithographing Inc 86069.22 Roadway Package System, Inc 4 43.67 Blue Cross 340.00 Cardinal Business Media, Inc. 2 175.00 Compuserve 19.90 Data Reproductions Corp 21842.00 IBM 1200.12 Ingram 1575.00 9 8 6 5 3 2 2 2 2 3. Write a script that attempts to insert a new vendor in the Vendors table (make up the vendor data). If the insertion is successful, the script should display this message: SUCCESS: Record was inserted. If the insertion is unsuccessful, the script should display a message something like this: FAILURE: Record was not inserted. Error_NUMBER : Some error message Refer to lecture WK3-Ch14-scripts(2) Slide#6