i need this query to run against 20 instances from main server that have linked server to those 20 instances.i want to change the [
@server] to the right instance via cursor and make the
SELECT statement to work.
how can i write the query accordingly?
declare @server varchar(50) set @server = ‘servername\instnacename’ SELECT N'<TD>’ + ISNULL( + ‘<p class=”datarows”>’ + (SELECT CONVERT(NVARCHAR(MAX),column_name) from [@server].db_name.dbo.table_name),'<p class=”datarowserror”>Not Avail’) + N'</p></TD>’
SELECT CONVERT(NVARCHAR(MAX),column_name) from [@server].db_name.dbo.table_nameOr is creating the script for it enough?