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
Prasad Bhogadi
www.inforaise.com