We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
DROP PROCEDURE IF EXISTS customer_sales $$ CREATE PROCEDURE customer_sales (in_customer_id INT) READS SQL DATA BEGIN DECLARE total_sales NUMERIC(8,2); SELECT SUM(NumberOfEmployees) INTO total_sales FROM dbo.Customer WHERE CustomerNumber=in_customer_id; SELECT CONCAT('Total sales for ',in_customer_id,' is ',total_sales); END; $$
Join the community of 500,000 technology professionals and ask your questions.