course there is a downside... the server can no longer precompile the
statements in the stored procedure, so you will lose all the benefits of
using a stored procedure. In other words, this stored procedure will run
slower than the others.
_____________________
Eric
_____________________
"You can tell the ideals of a nation by its advertisements."
-- Norman Douglas
"Jacob Cameron" <[EMAIL PROTECTED]>
09/10/2004 08:03 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: RE: SP IF help
I always just assign to a nvarchar(), and then append the string with the
condition, then run the query at the end, at least that's how I do it:
DECLARE @selectString NVARCHAR(100)
set @selectString='select ID, name, orderNumb from '
if @tablename = 1
set @[EMAIL PROTECTED] + 'bob'
else
set @[EMAIL PROTECTED] + 'frank'
EXEC sp_executesql @[EMAIL PROTECTED]
Jacob
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
