>>>>You can use dynamic sql

DECLARE @sql nvarchar(4000)
>>>>SET @sql = 'SELECT * FROM ' + @Table + 'WHERE ...'
>>>>EXECUTE (@sql)

>>>>
>>>
>>>Sergey,
>>>
>>>I was wondering, from your experience, is there much gain in speed if you put the dynamic SQL in a stored procedure, versus, sending this SQL statement to SQL Server through SPT (VFP)?
>>
>>Dmitry,
>>IMHO if you have full control on what's passed as parameters (or control them before processing for malicious code) speed wouldn't be a matter. IOW if you have full trust to the sender of those parameters then no problem, else ...:)
>>Cetin
>
>Cetin,
>
>I have not even thought of malicious code. But I don't see it as a problem in my case. As I am making baby steps in converting a very big application from VFP database to SQL Server, I often times have a question whether stored procedure is better. And since I don't know much on how to write stored procedures, I choose to write the code in VFP and use SPT.
>
>Thank you for your input.

Same here:) For the last week or so I've been dealing with SQL2005 T-SQL and assemblies as much as I can and I'm extremely impressed. Boy, it's huge in its every dimension.
Cetin