Steve - Thanks for adding to the discussion but I think I like Scott's simpler version on how to tackle this.

Scott - Do you know of a way to incorporate Count(hID) in there to get a count of the total number of rows per hPerson ? I tried it using...

Scott - a follow-up now that I've made this work.  so if the PERSOIN_HISTORY table had 5 rows for the same hPerson and I used teh criteria

AND row_num_desc = 2

I'm...

• This reply was modified 1 year, 2 months ago by YSLGuru.

Thanks Scott

Have you made any improvements to what Frederico provided that you'd be willing to share? Also have you been able to make it so you don't have to use teh...

Chris - I know this is like 2-3 years later but I tried your code and it doesn't work for me either. It will show me the tables that the...

So is this just another way of doing something like the below?  Where the below requires and alias  (CC)?  And by dropping the alias and the parenthesis you can just...

Jeff

Do you know if others would also use the term "Skip Join" so if I googled on SKIP JOIN I'd get info about this or does this not have a...

This suprised me to and it does work. It's not something I wrote. It's from the vendor who proivides our primary accounting software. My boss asked me to take a...

Unfortunately our cloud provider still has us on SQL 2016.

Thanks

Jeff - that's what I am doing now, just using Replace(). I wanted to know if there was a better way to do it and so far it looks like...

Gotcha. Hopefully someone like Jeff will have some clever way to improve on this as this is a regular fix I'm looking at having to do daily until our vendor...

That is what the first code segment is, the current solution. The second if for the tables structure, the DDL

• This reply was modified 1 year, 9 months ago by YSLGuru.

Yeah this is kind of what I figured would be the case. The handful of SP's/UDF's I've come across that do something like this are effectively replacing known HTML codes/characters...

• This reply was modified 1 year, 10 months ago by YSLGuru.

Unfortunately that's not an option in this case. I am limited to writing valid T-SQL statements so if there's a way in T-SQL to do this great otherwise no.

Thanks