Hi Jeff,

To clarify, no the Database is 100% active as it is a transactional Database. what I was attempting to add above was that there have been no code...

You original post talked about 1's and 0's.  You've now post data with only 1's and haven't posted the result that you're looking for.  I don't know about anyone else...

I was afraid of that.  I was hoping that the remnants of the parent id for each row might be left in the table.  I've never used HierarchyID except for...

Thank you for the feedback.  Just remember that the STRING_SPLIT() function does not currently guarantee any order in any version of on-prem SQL Server..  They finally figured that out and...

Am I understanding correctly that you say there have been no data changes in the server instance for 5 months and no one has changed any code in the server...

You're confused me and, perhaps, others.  How is it that your test data now contains a -1 instead of a 0 in the Div_Status column?  And what result do you...

Things look about as "packed" as they're going to get.  Not including what you posted before (graphic below for convenience), how much drive space do you have left on that...

I can't help here but I can tell you I'd be online with MS Support about this.  This sounds like a bug to me.

Thank you for the readily consumable data.  This should do it for you and it contains some protection from "Divide by Zero" issues...

 SELECT   companyid...

I would like to match this source table: CREATE TABLE [dbo].['TMI Sites $']( [Advertiser] [nvarchar](255) NULL, [Designated Market Area (DMA)] [nvarchar](255) NULL, [DV360 Site] [nvarchar](255) NULL, [Impressions] [float] NULL,...

Can you post the CREATE TABLE statement for the table, please? I might have a time-saving idea for you if the structure is right for it.

[EDIT]  I just noticed that this is almost identical to @kaj's good code.

This should help and it will also help prevent mistakes with spaces (like ratbak also helped prevent in...

• This reply was modified 4 years, 1 months ago by Jeff Moden. Reason: I just noticed that this is almost identical to @kaj's good code

See above.

Please see the article at the first link in my signature line below for how to post "readily consumable" data...

Sure.  Do a search for SQL Injection and try some of the methods for the way you're using @Table2 and @ColName.  @Table1 may not have the same...