zafarahmad (10/18/2014)
First of all thank you very much for a prompt reply to my query and here is the requested information:I am using Power Builder as a Front End: .....
I hope this will explain the situation. Again in my opinion these queries are irrelevant because they are proven correct and the same query shows different result on different PC(s) shows different results if we run from source code mean from Power Builder IDE and different from complied EXE File. To me its a bug in SQL Server 2008 R2 may be we need some patch / fix to install and yes I thing is that it is installed on Windows 7 Ultimate 64-Bit Operating System and MS SQL Server 2008 R2 is also a 64-Bit version recently I also installed Service Pack 3 for SQL Server and Service Pack 1 for Windows 7.
Thanks Again.
Zafar
Zafar in troubleshooting often we look at what is the same and what is different. The things that appear to be the same in your situation are the SQL query, the SQL Server, and the data.
Assuming the data is identical is in fact an assumption on my part. If the data is fully committed and there is no delete etc then it is the same for all cases. I will assume that this is the case.
Are the versions of PowerBuilder the same from one machine to the other? And are the drivers being used the same? Like is the same SQL Server driver and specific version the same? When running in an exe is there anything in the "bin" file that would apply that does not when you run the report native in PowerBuilder?
If all this is the same then something else is different.
M.
Not all gray hairs are Dinosaurs!