Problem in sql joins complex query to execute on remote server

• vidhyasyd

  Newbie

  Points: 0

  More actions

  January 4, 2016 at 6:53 pm

  #151449

  Hello,

  I have one sql query which has many joins and quite complex .

  The same query working fine on local machine but sometimes not working on remote server . not showing result sometimes and sometimes showing result. if we try to run same on sql query window on server then it works fine .

  it happens for 1 or 2 records others working fine.

  any reply will be highly appreciated.

  Help needed urgently.

  Thanks

• Sudhakar G

  Newbie

  Points: 0

  More actions

  January 20, 2016 at 7:34 am

  #1853131

  Since you say it doesn't work for 1 or 2 records...

  Are you filtering data in where condition? what kind of data types of the columns that the query refers to? varchar, char? Hope you have same collation settings in your local and on the server.