May 4, 2012 at 6:06 am
I need to Return all Records from TableA That Have a Record in a Table called CompanyNumbers using an OpenQuery.
The Linked Server Name: LinkedServerA
WHERE (EXISTS (SELECT * FROM CompanyNumbers WHERE TableA.CompanyNumber =CompanyNumbers.CompanyNumber ))
Could someone please provide me the correct syntax?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 4, 2012 at 6:23 am
I tried an INNER JOIN and I still get a syntax error.
Any help would be greatly appreciated.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 4, 2012 at 6:43 am
Post has been moved to the following thread:
http://www.sqlservercentral.com/Forums/Topic1214273-338-1.aspx?Update=1
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply