Thanks as always for weighing in Jeff. I've read up on salted hashed values before, so conceptually it makes perfect sense to me. But I've never actually implemented anything like...

I definitely appreciate your feedback. Maybe I am just overthinking it. Thanks!

Yes, my concern with an incrementing, numeric, identity-type column is that I know it's generally discouraged to make those client-facing. And what I specifically need here is a reasonable-size value...

I'm still unclear if the CATCH block is even executing or if it's successfully firing the logging SP or not.

Yeah that left join isn't going to function as a left join.

Dumb question probably, but have you confirmed that SP_LOGERROR is capturing the event every time it errors? If so, have you confirmed in the resulting log that @ISSUE_NUM was a...

I came to the same conclusion. 🙂 I dumped the UNPIVOT results into a temp table and indexed it as you suggested.

Wow, never used results to text, and never knew about "alt + select"! Thanks. Still, getting any semblance of clean formatting in my post took ages. Hope it's helpful to...

Thanks everyone! Jason, just a quick note to say that my actual source table is a denormalized mess. I did an UNPIVOT to get it into the above shape, so...

Awesome, thank you Jeff! I will test this out tomorrow and post back!

Holy cr@p. What a nightmare.

I'm in the San Francisco area, but planning to travel to Michigan next year. Maybe I can catch you at an event!

OP claims "Same predicates, same filters"