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...

declare @qtramt1 numeric(11,0)=94500;

select format(cast(@qtramt1 as bigint), 'd14');

• This reply was modified 5 years, 5 months ago by Steve Collins.
• This reply was modified 5 years, 5 months ago by Steve Collins.

That's intended to work for 1 id from #sale_order at a time.  Is that how you're intending to update the #sale table?

drop table if exists #sale_order;
drop table if exists #sale;
drop table if exists #sale_result;
go

create table #sale_order(
    id int identity primary key
    ,item_id...

Why not update the 'sale' table directly?  Do the 'sale' table and 'sale_result' table always have the same # of rows?  If so, could this be implemented by making 'sale'...

Is it correct: rows with NULL ship_date in the 'sale' table are created before the corresponding ship_date in the sale_order table?  Units always ship in the quantity ordered?

That's nice!

The way this is set up isn't straightforward because there's no way to join to the duplicated rows in sale WHERE ship_date is null.  I re-jiggered the script to not...

• This reply was modified 5 years, 5 months ago by Steve Collins.

This is simpler

declare
  @start_dt              datetime='2019-12-02',
  @end_dt      ...