all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

Rcvg different result sets for same report - virtually same report time


Rcvg different result sets for same report - virtually same report time Charlie P
3/22/2005 4:46:50 PM
sql server reporting services:
I have a report that I have created using a stored procedure and have
found that I will get result set A at 7:01am and run it again at 7:03am
get something slightly different.

This report runs against SQL Server db. What do I need to look at?

Thanks
Re: Rcvg different result sets for same report - virtually same report time Wayne Snyder
3/22/2005 7:58:50 PM
If this is a multi-user system, then the other people may have done some
work which is reflected in your new query.... If I felt like the query was
problematic... I would copy it out of RS and use Query Analyzer to execute
it and play with it until I knew it was correct...

hope this helps.


--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

Re: Rcvg different result sets for same report - virtually same re Charlie P
3/23/2005 9:55:03 AM
Well, that's just it. I don't feel like the query is problematic and the
users can not update data within two minutes enough to make that kind of an
issue - at least not with the type of data we are dealing with and the steps
one goes through to update it.

Here is a copy of the stored procedure. Could you kindly take a quick look
at it to make sure that I have not mistakenly forgotten anything?

Thanks for your help.



[quoted text, click to view]
AddThis Social Bookmark Button