Instead of returning the SSN (which is being sent to the procedure already) could you return COUNT(*)?  Count always returns a value.

It's data obfuscation project, thus no strict rules what value should be, rather it should be random. Each row should have its own value. When we are out of...

It randomly picks one of the words

;with data_cte(which_word) as (
   select 'some' union all select 'word' union all select 'here')
select top(1) 
  which_word
from
 ...

This is a beginning and it might get the OP past the id assignment issue.

drop table if exists #src_data;
go
create table #src_data(
  EmpId    ...

Now while i was trying to implement merge, problem is how to assign new identifier value for new record (it should be max value +1 , and this column...

Right there with you.  I wouldn't bother on that other thread, though.  That subject keeps cropping up over and over and over and some of the participants do too. ...

Jeff are the results reversed?  It lists FORMAT d14 method as 802ms.  Maybe copy/paste gone off?

And, please... for the love of your servers and your customers, stop all the...

@scdecade - your solution will not work for the OP.  The trim function is not available on SQL Server 2016 and would need to be replaced with a rtrim(ltrim(...)). ...

If using nested replace then this could be done in the select list.  What if the list of replacements is variable?

select 
  ltrim(rtrim(replace(replace(replace(replace(replace(Employee, '<td><br>', '||'), '<td>',...

Here's a table based scalar function approach.  Actually, I had a very similar issue this week and this code is lifted from that solution.  Which I'm not super happy with...

Imo there is...

I am trying to create a row in a table that is created as: CREATE TABLE tax_table ( Data char(275)).  Within this table the "Data" consist of 4 fields that...

Jeff, maybe so, maybe so.  It appears the OP's...

One way to do this would be to do search and replace.  It would nice to have a regex but it depends on your faith in a single pattern.  Per...

I am trying to create a row in a table that is created as: CREATE TABLE tax_table ( Data char(275)).  Within this table the "Data" consist of 4 fields...