Post reply

Problem in sql joins complex query to execute on remote server

  • 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

  • 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.

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

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