Why am I getting different results between SQL Server Reporting Services and SQL Server 2005??
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).