Hi Dwain, these work just as needed! Thank you so much for the help (and for the explanation). And re:flattery - You've bailed me out two or three times. I'm...

I was hoping you might show up 🙂 I'll give it a test run first thing! Thanks(!), and I'll write back soon.

Thanks for the reply! The article was helpful. However, I need to do more than left join to a row of sequential dates. I need to carry over the total...

Thanks to you both - I really appreciate the advice. It looks like I'm out of luck: the connection made always uses SQL Server. But this saved me a week...

Thanks again on this. This is the closest thing seen anywhere regarding an SSRS monitoring query to end all others. Really good stuff.

That is exactly what I needed! Thanks alot for that query.

That's exactly what I needed. And good catch on the -4. I modified that section. Thanks alot!

...I should probably add that I'm needing something that will capture the data every week. We have a Monday run that shows progress in varies areas since the previous Monday.

Excellent, that's exactly what I'm looking for. (Seems very standard; I'm not sure why my Google searches didn't find it. Must have been using the wrong search terms!)

Hi MM,

Thanks again for the reply. Would you mind showing me what a TRY...CATCH would look like with my sample data? I've read around on this function, but I've never...

Thank you both very much for the help.

Thank you so much! This is very helpful.

...here's an example of another version I've seen: NOT LIKE '%[^0-9]%'

Yep, that's perfect. And I love that you named yours "uglysearch" 🙂 Indeed, but necessary. Thanks! And no production runs - I promise!

Those are great, and exactly what I'm looking for. But I'm also wanting to check for values in rows. So literally looking for everything.

I don't even know if checking in...