Thanks, Steve.  Thank you for the feedback.

I'd also considered doing the REVERSE thing and using 4 CHARINDEXes, for such a few elements, it's usually faster than a splitter and re-pivoting,...

Your posted example is great but please Read'n'Heed the article at the first link in  my signature line below for future posts for how to post "Readily Consumable" data to...

I've found that to be...

If you're on 2022 then you could use DATE_BUCKET:

WHERE YourDateTimeColumn >= DATE_BUCKET(DAY,1, GETDATE(), CONVERT(datetime,'19000101 16:00:00'))
  AND YourDateTimeColumn < DATEADD(DAY, 1, DATE_BUCKET(DAY,1, GETDATE(), CONVERT(datetime,'19000101 16:00:00')))

Another method...

When doing (upsizing wizard), problems appeared in copy (sql server), so I deleted it and installed it again, and after I tried (import), it worked and the database was...

onetsql,

Nice link.  Thanks.

I'll likely never make the attempt on these forums because it's not permanent to this forum.  If it goes away, any answer...

Created a table in such a way, each rowsize is one 8K page.

Now when I execute this

SELECT T.name as 'Table', ix.index_id, ix.[name] AS IndexName, ix.type_desc AS IndexType, [ips].[index_level],...

So what was your final problem and resolution?

Hi Jeff

Yeah vendor is aware of this issue. But get where you are coming from for sure.It was caused by a crappy import tool they wrote.. Really the records...

I seriously wish you the best of luck.  Get your QA/UAT started on checking for bad info/reporting/etc.

Personally, it was the DB Vendor's code that allowed the "duplicate" to begin with and I'd ask them rather than changing data that may have a substantial impact somewhere else. ...

It can't... there's no ORDER_ID column in...

It can't... there's no ORDER_ID column in the Vendor...

You are correct.  Each 7000 byte + the ID row occupies 1 page.

On my box, I'm always getting 2 reads more than the number of leaf level pages regardless of...