I've run them both in SSMS and they both run fine, both producing the expected results.

Something with the Iif parameter isn't right. It's like the "WHERE provider = "...

I added the spaces like Jason mentioned (after the "LIVE" and before the "WHERE"):

="SELECT rss.TripDate, rss.Provider, rss.[Route]" &

", rss.SETime, rs.SETime " &

" FROM [dbo].[RouteScoring_SnapShot] rss (NOLOCK)" &

" LEFT JOIN [dbo].[RouteScoring]...

...so apparently one fix leads to another issue...

It works great now ...if the parameter is KC. Otherwise, the report runs but I get no data if it's something other than...

thankyouthankyouthankyou.

I so rarely work with expressions in SSRS that I never would've caught that.

And once again, thank you.

😀

I stumbled across this thread today and wondered if I might enlist more help on this topic. I'm running the supplied queries but with the namespace for 2008 R2...

I guess I'm just looking at this process in my own environment. I can't seem to think of any scenario where i'd have to go back to a point...

I think you might be. The nightly restore I mentioned is on a different server altogether, for a different purpose, outside of the log shipping process and done only...

Hey thanks for the confirmation. I was second guessing myself there.

Thanks for the advice too. I actually restore last night's backup to our backup server each morning as...

Makes sense.

Thank you! I appreciate the assistance!

Another good point. Thanks for all the help.

Question though, if this column is in Date format and the other fields are smalldatetime and I do a DATEDIFF between the two,...

You bring up a good point, which I totally overlooked, not reviewing how I manipulate the dates in the rest of the code. I do indeed have to convert...

Thanks so much for your input. Actually, the answer came to me not long after I posted the question. And trust me, it was a "duh" moment...

I had...

Doh! (*picture some forehead slapping here*)

Wow. What a difference once space makes. Thank you!!!!

😀

I think that just might do it. Thanks alot!

Craig! I think that's it! Wow, what a difference a little <> makes. hehe

Your query does bring up all the caseids that are still open, and that have associated...