Hi,

Thanks for the response. the following would also work:

declare @machineName varchar(20)

select @machineName = macname from machine

exec('select * from [' + @machineName...