I don't think it would be a huge performance hit making it dynamic except that the execution plan is not going to be re-used.

>Thanks Sergey (and Borislav & Naomi). I guess I'll need to do the dynamic SQL if I want to implement this. =0(
>
>>Can you post your actual query? Does it return a lot of records?
>
>The query doesn't matter ... I can figure out how to make it dynamic, that's not hard. I just didn't want to do it if I didn't have to. Not quite as elegant of a solution. =0(
>
>But why do you ask if it returns a lot of records? Is there a performance hit executing dynamic SQL?
>
>~~Bonnie
>
>
>
>>Hi Bonnie,
>>
>>Nope. I don't think it can be parametrized. You'll have to use dynamic SQL.
>>
>>Can you post your actual query? Does it return a lot of records?
>>
>>>I bet Sergey can figure out a way to do this!
>>>
>>>If I have the following SQL statement, it works fine:
>>>
>>>SELECT CodesKey AS 'codesdeptkey', * from codes
>>>
>>>I'd like to parameterize this, but if I try this it gives an incorrect syntax error:
>>>
>>>DECLARE @KeyName varchar(50)
>>>SET @KeyName = 'codesdeptkey'
>>>SELECT CodesKey AS @KeyName, * from codes
>>>
>>>Any ideas??? (other than obvious setting a string to the whole SELECT string and then EXECing that ... the SELECT string is obviously more complicated than what I've indicated above).
>>>
>>>TIA,
>>>~~