Linkserver issue

• sammy10691

  Newbie

  Points: 3

  More actions

  August 21, 2015 at 6:41 am

  #303650

  HI All ,

  I Am faing a problem while calling the code using a link server .The query is able to fetch the datawhen we modify the query with in instead of notin in the select statement of the query .Please assist.

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  August 21, 2015 at 6:43 am

  #1821660

  sammy10691 (8/21/2015)

  ---

  HI All ,

  I Am faing a problem while calling the code using a link server .The query is able to fetch the datawhen we modify the query with in instead of notin in the select statement of the query .Please assist.

  Without seeing the query? Are you serious?

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

• Lowell

  SSC Guru

  Points: 323574

  More actions

  August 21, 2015 at 6:52 am

  #1821663

  the [IN]/[NOT IN] (SELECT SOMECOLUMN FROM SECRETTABLE) has to explicitly exclude nulls.

  NOT IN(SELECT SOMECOLUMN FROM SECRETTABLE WHERE SOMECOLUMN IS NOT NULL)

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!