Problem in sql joins complex query to execute on remote server

  • vidhyasyd

    SSC Rookie

    Points: 27

    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

    Ten Centuries

    Points: 1277

    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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply