Using a variable for a column name

[JefB]

Is it possible to feed a column name to a query as an argument in a procedure?

My goal is a procedure to pull the value(s) from a single field, on the fly using the following code:

CREATE PROCEDURE [dbo].[Eval_Test_Proc]

@FldName text

AS

Select @FldName from

(SELECT Evaluee, Initiative, PosAttitudeCaller, PosAttitudeCoWork, GiveFeedback, Extreme
FROM dbo.TeamEval_Data) x
GO


However, when I execute the procedure:
EXEC dbo.Eval_Test_Proc 'Initiative'
All I get is the word "Initiative"

Any suggestions?

JefB

 

[uerobertson]

Have you looked at faq183-3132 ?

 

[knobe]

Try this

CREATE PROCEDURE [dbo].[Eval_Test_Proc]

@FldName text

AS
DECLARE @sql varchar(100)

select @sql='Select ' + @FldName + ' from dbo.TeamEval_Data'

exec (@sql)

GO

 

[JefB]

Thanks all. Now for the next part: How do I put this into a custom function?

For instance; I want to return the value IN @FldName:

CREATE PROCEDURE [dbo].[Eval_Test_Proc]

@FldName text

AS
DECLARE @sql varchar(100)

select @sql='Select ' + @FldName + ' from dbo.TeamEval_Data
Where Status = A'

exec (@sql)

GO

Evidently, I cannot execute a procedure within a custom function.

JefB