I hope this helps you

CREATE PROCEDURE GetFacilities

 @userID NVARCHAR(100),

 @language NVARCHAR(100)

AS

DECLARE @sql_str VARCHAR(1000)

SET @sql_str = 'SELECT Name,

(SELECT ' + @language + ' FROM lkpfacilitytype WHERE ID = Type) AS Type,

 Address1,

 Address2,

 City,

 State,

 ZIP,

 Country,

 Phone,

 Fax,

 WebSite

FROM tblFacilities

WHERE userID = ''' + @userid + ''''

EXEC (@sql_str)

GO