This is the sample stored procedure called in this question. Use the following to create the stored procedure. I used the sample AdventureWorks2017 database from microsoft.
CREATE OR ALTER PROCEDURE GetContactFormalNames
AS
BEGIN
SELECT TOP 10 TRIM(CONCAT(Title, ' ', FirstName, ' ', LastName)) AS FormalName
FROM Person.Person
END
This stored procedure returns a single result set that contains one column of data, which is a combination of the title, first name, and last name of the top 10 records that are in the Person.Person table.