CREATE PROCEDURE InsertPublisherDetails(
	@publishername NAME,
	@medianumber varchar(50),
	@address ADDRESS,
	@city NAME,
	@state NAME,
	@zip ZIP,
	@phone PHONE,
	@contact NAME,
	@fax PHONE,
	@emailid EMAIL,
	@notes NOTES,
	@cname_advision varchar(2)
) AS
BEGIN
	SET NOCOUNT ON -- this is what I had to add
	Declare @Country JdtID;
	SELECT @Country = CountryID FROM Country WHERE cname_advision =  @cname_advision
	if @Country is NULL BEGIN
		raiserror('Cannot find the Country ''%s''!',11,1,@cname_advision);
		RETURN;
	END

	INSERT INTO Publishers (
	 publishername, medianumber, address, city, state, zip, phone,
	 contact, fax, emailid, notes ,CountryID
	) values (
	 @publishername, @medianumber, @address, @city, @state, @zip, @phone,
	 @contact, @fax, @emailid, @notes, @Country
	)

	RETURN @@identity
END