@lan2022nguyen ,

Thank you for the feedback.

You cannot do INCLUDEs on Clustered Indexes, period.  The reason why is that the Clustered Index IS the table and it already includes all the data.

I posted a link further...

Speaking of volunteers, the Ohio North SQL Saturday (formally SQL Saturday Cleveland) by the Ohio North Data Training group (formally, a PASS group that continues because of people like Grant...

I've not ever had to do this before.  I started at sys.schemas and worked by way up to the other two sys views but, like I said, I've not done...

Ah.  Got it.  Thanks.

You might want to...

First, let me say that I have a grand and genuine appreciation for people that write tools and share them.

I don't, however, have an appreciation for code that doesn't even...

@rajemessage ,

I've found that most people that want to know how to do this are solving a problem the wrong way.  What is the end use of this concatenated string...

@AG , It was running as  legacy. I just took over..I have removed 'Index Maint' from the activities..and also i m not getting any complaints on performance, suggesting ,...

BTW and just to be sure... I totally agree with that statement and so do...

Thanks for the reply Grant.  I agree using this data must be used with caution.  My goal now is to make the stored results more aware of these situations...

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