declare @id varchar(112),@tb varchar(112),@keyword varchar(2)
set @id=1
set @tb='FilePolicy'+@id
if object_id(@tb) is not null
begin
declare @s nvarchar(4000)
set @s=N'select @keyword=left(FilePolicy,2) from '+@tb+' where usergroupid=23'
EXEC sp_executesql @s,N'@keyword varchar(2) out',@keyword out
print @keyword
end
set @id=1
set @tb='FilePolicy'+@id
if object_id(@tb) is not null
begin
declare @s nvarchar(4000)
set @s=N'select @keyword=left(FilePolicy,2) from '+@tb+' where usergroupid=23'
EXEC sp_executesql @s,N'@keyword varchar(2) out',@keyword out
print @keyword
end