• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

getting different results

Why  am I getting different results between SQL Server Reporting Services and SQL Server 2005??

for e.g
if i run following quey on the MSSql Server it returns 226, but on the SQL Server Reporting its 402

select sum(Hours) from table1
what would cause to this problem?? service pack or anything
I have checked following items

1. Connection String - check the server, database name, credentials & etc&.
2. Parameter  e.g. the format of the Date parameters& it may pass different date format&
4. Also, you can use the MS SQL server Profiler to side view the query (cross-verify).

Please help??

 
0
nadun
Asked:
nadun
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the 2 results must be coming from different tables. you MUST have overlooked a detail.
0
 
nadunAuthor Commented:
Nop both refer to same Server --> View, it seems to be problem with the  sum function, when i remove the sum then the results are exactly same  

see attached file
problem.jpg
0
 
nadunAuthor Commented:
I have figured out the problem... thanks a lot for your help
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now