Thanks much, Lowell. We may have not been aware of how easily this can be accomplished and I'm really glad I asked. I'll run it by my coworker...

Removing this posting and starting another thread

I sure wish one of the local heavyweights would give this a shot and post your solution here. Trying to do it in a single query is driving me...

I've been faced with this problem many times and never adopted a standard methodology for dealing it with but am quite sure that my attemps were RBAR.

Would this approach be...

I much appreciate the effort going into this article. The most important "take away" for me is the strong similarities between SSRS in R2 and the current Report Builder....

I’m a little surprised at the comments that there were more C/C++ developers than for the earlier versions of VB. That may be true but in my experience the...

In my part of the world (Phoenix metropolitan area), it is not difficult to find work as a SQL developer. The company I now work for is always looking...

My working definition of failure for years was that no one fails until they quit trying. But what...

Consider getting yourself grounded in statistics. It will be every bit as challenging as becoming fluent in T-SQL but if you are going to hold yourself up as someone...

Thanks Markus. This looks...

Thanks for the response. 🙂

I mean that I want to re-initialize everything particularly the temporary tables. I know I can drop them etc. but I would prefer a clean disconnect, reconnect.

This site has some really good pointers on passing values in your url.

http://www.mssqltips.com/tip.asp?tip=1336

Are you more interested in administration or TSQL?

If it is TSQL consider that there are a bunch of report writers out there that aren’t really qualified to talk about (as...

One of my heroes is Joseph Campbell and he basically says that each of us has to decide whether or not to say "yes" to life. That would include...