LISTING 1: Modified Procedure

CREATE PROCEDURE GetLocations
AS
SET concat_null_yields_null OFF
SELECT Publisher_Location = city + ', ' +  state + ', ' + country
FROM pubs..publishers
SET concat_null_yields_null ON
SELECT Employee_Location = city + ', ' +  region + ', ' + country
FROM Northwind..employees