Thanks.

Sorry, about that...I should have referenced. I found it at:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=828306&SiteID=1.

There were a few postings on different threads that were pointing users to create their own rounding functions...

---

If you choose to use the Round() function within a Reporting Services report there are three parameters required to...

Thanks Jeff,

   I guess I wasn't very clear in my initial post.  My problem isn't with SQL Server's rounding function, its with Reporting Services rounding function.  If I round in...

Thanks!  That narrows down the wires that were crossed for me.  I won't have a chance to test it for at least a few days but I'll keep you posted.

Thanks...

That would probably work.  However, I am not sure what happens if the SP were called again before the first call could finish executing.  This SP is called from a...

Follow-up question for Ian Yates' post.

I have been operating under the belief that you cannot "insert into a table variable from an exec statement."  If that is possible I believe...

Thanks for the suggestion.  We have tried that and although it works, the limitations of Dynamic SQL don't fit well with the rest of our needs. 

The return from our...

Nice article, right to the point.

I have a question (since this is "Part 1") regarding Part 2.  Do you know of any way to pass in variables through the OpenQuery...