Glad you got it working.   Getting just 3 rows to cross the network instead of 8 million is a pretty amazing demonstration of why Linked Server JOINs can be a...

If you want help, first you have to have something that has some shot at working.   You've described a filter table with only an Fname column, but are joining to...

To be honest, storing data in JSON format and then expecting to update it using the abilities of an RDBMS, is not particularly practical.   JSON is built for data exchange,...

Yes, that's what I think, based on what you've said so far.   I'd be looking for any characters that are not [a-zA-Z 0-9].   If you find any, then you may...

I'm pretty I now see what the original poster is after.   Apparently whenever ISNULL(RunDate, '') = '', he/she wants a pair of dates representing the range of dates encountered since...