I have a doubt.What is the best practice in following the DECLARE statement?

It is DECLARE @variable1 datatype,@variable2 datatype

or

DECLARE @variable1 datatype

...

Thank you so much Lowell.Now its working fime after using OPENQUERY.Thanks a lot 🙂

Why you have used OPENQUERY?is that the syntax to fetch the records from the linked server?

I have written an stored procedure that read some records from the remote table on the linked server.Actually whats the problem is When I execute the Stored Procedure ,the execution...

I have written an stored procedure that read some records from the remote table on the linked server.Actually whats the problem is When I execute the Stored Procedure ,the execution...