The @city needs to stay as a parameter entered manually into the procedure. It's part of the instructions I was given.

Also, right here is where I'm trying to test the condition to make it print that particular message:

SELECT CompanyName

FROM Customer

WHERE CompanyName IS NOT NULL

AND City = @city

UNION

SELECT CompanyName

FROM Supplier

WHERE City = @city

SET @rowcount = @@ROWCOUNT --This is me trying to set the variable to check rows returned

IF @rowcount = 0 --Here is the conditional statement

PRINT 'No Suppliers or Customers in the city of ' + @city --and here is the attempt to print message