Create a stored procedure, called sp_customer, that takes in a CustomerID as a parameter, and then returns a select statement that shows the full name of the customer, the full name of the employee that does the transaction, the name/code of the branch where the transaction was done, the transaction type (Deposit, or Withdrawal), and the amount of the transaction. The columns returned should be cust_full_name, emp_full_name, location, transaction_type, amount, customer_id.

 

Transcribed Image Text:

File + CIS435LProject Object Explorer Connect Edit View Query Project Tools Window Help New Query MX DAX + AP AP AllObjects BCIS435LProject Ch MSSQL19CVD48 (SQL Server 15.0.4280sa) B Databases HH + + + System Databases Database Snapshots AdventureWorks2019 Ready + + Database Diagrams Tables System Tables FileTables External Tables Graph Tables WBank.AccountType + WBank.CheckCashing + WBank.Customers WBank.Deposits WBank.Employees WBank.Locations WBank.Withdrawals + Views External Resources Synonyms Programmability Service Broker Storage Security Examples L_LUNCHES MyGuitarShop ProductOrders Unit1 Security Server Objects ▾ Replication PolyBase Management XEvent Profiler Type here to search ▷ Execute E ✓@@@ 150 % ▾ NDX X SQLQuery1.sql - MSS...5LProject (sa (61))* X --Question 6 CREATE PROCEDURE sp_customer Results Messages Ln 2 B CustomerID DateCreated 1 2 3 4 5 6 7 8 8 9 9 10 10 11 11 12 12 13 13 14 14 15 15 16 16 < 1 2 3 4 5 6 7 ✔Query executed successfully. Col 29 Hi 5: 2023-03-25 869162659 2023-03-25 370559552 2023-03-25 643822818 2023-03-25 659977268 2023-03-25 892939173 2023-03-25 117806973 2023-03-25 415997917 2023-03-25 185336973 2023-03-25 623432261 2023-03-25 794734636 2023-03-25 207568092 2023-03-25 2023-03-25 992477305 268306669 2023-03-25 2023-03-25 2023-03-25 ? 665677184 611997686 407095485 L Ch 29 1 2 3 1 2 3 1 2 3 Account Number Account TypeID FName Kaia Jamar Marc Jaydon Sierra Gary Lilliana Marquis LName: Flores Manning Carson Frye Marquez Madden Boone Hoover Jewel F Jadyn F Carson Dyer Yair Stokes M Keenan Mcpherson M Amav Marshall M Trenton Santiago M Hallie Clayton F Madalynn Guerrero F Y 1 2 3 1 2 3 1 D INS @ = Gender Address F M M M F M F M 2596 Murry Street 1262 Pearl Street 3489 Clover Drive 7190 Summit Street 4551 Bames Street 2209 Conifer Drive 514 Cambridge Drive 3067 Pine Garden Lane 806 Geraldine Lane 1426 Sundown Lane 3808 Murry Street 2946 Pearl Street 275 Clover Drive 808 Fordham Dr. 1471 Bames Street 9 Raccoon Run City Virginia Sacram Colorad District. Orlando Seattle Phoenix Atlanta New Yo Austin Virginia Sacram Colorad District Orlando Seattle MSSQL19CVD48 (15.0 RTM) sa (61) CIS435LProject 00:00:00 25 rows 2:36 PM > 2/20/2022 易 File + CIS435LProject Object Explorer Connect Edit View Query Project Tools Window Help New Query MX DAX + AP AP AllObjects BCIS435LProject Ch MSSQL19CVD48 (SQL Server 15.0.4280sa) B Databases HH + + + System Databases Database Snapshots AdventureWorks2019 Ready + + Database Diagrams Tables System Tables FileTables External Tables Graph Tables WBank.AccountType + WBank.CheckCashing + WBank.Customers WBank.Deposits WBank.Employees WBank.Locations WBank.Withdrawals + Views External Resources Synonyms Programmability Service Broker Storage Security Examples L_LUNCHES MyGuitarShop ProductOrders Unit1 Security Server Objects ▾ Replication PolyBase Management XEvent Profiler Type here to search ▷ Execute E ✓@@@ 150 % ▾ NDX X SQLQuery1.sql - MSS...5LProject (sa (61))* X --Question 6 CREATE PROCEDURE sp_customer Results Messages Ln 2 B CustomerID DateCreated 1 2 3 4 5 6 7 8 8 9 9 10 10 11 11 12 12 13 13 14 14 15 15 16 16 < 1 2 3 4 5 6 7 ✔Query executed successfully. Col 29 Hi 5: 2023-03-25 869162659 2023-03-25 370559552 2023-03-25 643822818 2023-03-25 659977268 2023-03-25 892939173 2023-03-25 117806973 2023-03-25 415997917 2023-03-25 185336973 2023-03-25 623432261 2023-03-25 794734636 2023-03-25 207568092 2023-03-25 2023-03-25 992477305 268306669 2023-03-25 2023-03-25 2023-03-25 ? 665677184 611997686 407095485 L Ch 29 1 2 3 1 2 3 1 2 3 Account Number Account TypeID FName Kaia Jamar Marc Jaydon Sierra Gary Lilliana Marquis LName: Flores Manning Carson Frye Marquez Madden Boone Hoover Jewel F Jadyn F Carson Dyer Yair Stokes M Keenan Mcpherson M Amav Marshall M Trenton Santiago M Hallie Clayton F Madalynn Guerrero F Y 1 2 3 1 2 3 1 D INS @ = Gender Address F M M M F M F M 2596 Murry Street 1262 Pearl Street 3489 Clover Drive 7190 Summit Street 4551 Bames Street 2209 Conifer Drive 514 Cambridge Drive 3067 Pine Garden Lane 806 Geraldine Lane 1426 Sundown Lane 3808 Murry Street 2946 Pearl Street 275 Clover Drive 808 Fordham Dr. 1471 Bames Street 9 Raccoon Run City Virginia Sacram Colorad District. Orlando Seattle Phoenix Atlanta New Yo Austin Virginia Sacram Colorad District Orlando Seattle MSSQL19CVD48 (15.0 RTM) sa (61) CIS435LProject 00:00:00 25 rows 2:36 PM > 2/20/2022 易

Answer rating: 100% (QA)

sql CREATE PROCEDURE spcustomer CustomerID INT AS BEGIN SELECT cfirstname clastname AS custfullname ... View the full answer