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.