@sathishkm-2

Did either of Ed B's solutions work for you?

If not, could you post what the output should look like using the test data you've provided?  I'm also not sure what...

My online index rebuild job for a 200G table with 40mil rows took me up to 30hrs to complete, this is a once off activity done since we have...

... I also gave a presentation on how to secure it properly way back in (IIRC) 2013 at the now defunct Kalamazoo, MI SQL Saturday.  It's where I...

Lordy... the wondrous things I've used it for... there's no way for me to list everything I've used it for.

Exporting files is one of the big ones but also the...

I have a number of friends moving to SQL 2022 and haven't had Jeff's issues. If you look at Brent's version spread (For his customers), lots are/have moving/moved to...

I wouldn't use DELETE on a year old table.  That'll be a lot to delete and it'll cause a "log file explosion".

I probably also wouldn't do a whole year at...

I totally concur.  Back in the late 90's and early 2000s Hoshin Principles; Greenbelt and Blackbelt training; Design-for-Six-Sigma, all stressed the importance of the "voice of the customer" and...

A lot of links for that incident show up with the following search.

https://duckduckgo.com/?q=robot+suicide

"Bump" to make the 2nd page of the discussion show up.

The greatest technical debt I have ever experienced is when we migrated from SQL Server 2016 to 2022.  That means that I'm still experiencing that "joy".  Overall, "It just runs...

Jeff - I'm going with Scotts recommendation which sticks with CAST and not FORMAT.  That said, just out of curiosity do you know how much data/rows need to be...

Heh.. "next time".  You're saying that because someone already did it but... they did...

You're not going to use this data as points in time, but as intervals, so model it that way

Create table events (event_number integer not null primary key, event_start_timestamp dateime2(0)...

{sarcasm on}

WHAT??? AI LIED??? Surely, you jest!  It's going to take over all our jobs, right?  RIGHT? 😉

{sarcasm off (for the moment)}

If you use FORMAT anyplace where there are a lot of rows, I can only wish you luck for performance because you're going to need it.