Query Analyzer Vs. SRS... different results

    Date: 10/19/06 (C Sharp)    Keywords: database, sql

    So, I'm posting here in hopes that someone has encountered something like this before and knows a way to fix it.

    this is a larger issue, but the crux of it is simply this query (yes it calles a sql server stored proc):

    spRPT_TKT_ThreeDayCountReport null,null,null,null,null,null,'9/16/2006','10/15/2006',null,null,null,null,null,null,null,null,null


    When executed from query analyzer (paste in, hit f5) connected to the production database I get one set of results.
    When executed as a dataset (command type: text) in Sql Reporting Services, I get a different set of results.

    The row counts and MOST of the associated data are exactly the same, the problem lies in SOME of the individual items are 0 (not null, just 0), in all cases these are sum(isnull(-variable-),0) items in the Sproc.

    I am at a loss for why the results to this query are different from one application to the other. (and they are 100% reproducable).

    any ideas?

    Source: http://community.livejournal.com/csharp/78075.html

« Old-school databinding and... || Updating multiple rows in sql »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home