How can I pass the linked servername as variable in the stored porcedure.?
I have multiple linked servers having identical databases and I have to use this SP to fetch data from them.
the statement in SP is as below :
select invoicedate,invoiceno,invoicenet from [SVR1].TestPOS.dbo.invoice_header
how can I replace [SVR1] with a variable..?
thanks in advance