Jack Corbett (10/22/2014)

---

katland226 (10/22/2014)

---

Well, I just realized that the message is indeed printing... But instead of printing the message in the results tab, it instead prints in the...

Well, I just realized that the message is indeed printing... But instead of printing the message in the results tab, it instead prints in the messages tab.

Okay, so it's working,...

And I am using Microsoft SQL Server Management Studio. I am looking for the results to appear in the output window, where they always do.

It still returns the same thing... that is, nothing.

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...

CREATE PROC KRCityContacts

@city varchar(20) = NULL

AS

DECLARE @rowcount int

IF @city IS NOT NULL

BEGIN

SELECT CompanyName

FROM Customer

WHERE CompanyName IS NOT NULL

AND City = @city

UNION

SELECT CompanyName

FROM Supplier

WHERE City = @city

SET @rowcount = @@ROWCOUNT

IF @rowcount...

This is how I executed the procedure:

EXEC KRCityContacts 'Asheville'

But I only want to show the results, not the actual row count - I just want to test it as a...

Evil Kraig F (10/9/2014)

---

It comes down to the fact that you've built a large parameter list at the top, and you're expecting that to be the declaration for all local...

It seemed that the main issue was actually the State variable. Apparently, it had been confused for an integer; after using CONVERT that one, I stopped receiving the error.

Thank you for your help, both of you. But while I think I understand what you're getting at, I guess I was kind of foggy on how to fix it:

CREATE...