Ditto that and love your post.  Thanks for taking the...

@rajemessage 14195 ,

Enquiring minds want to know... did the non-XML method work for you?😋

Does anyone realize that if the docs are stored on the file system as opposed to a blob in a table, the need to scan them is then part...

Heh... I remember my Grandmother telling me when I was quite young, "Figures can lie... and liars figure". She was so right even back in the late 50's when she...

At least read the latest posts. 🙁  Kaj wrote a solution for you and I tweaked...

You've just gotta love people that give a super low rating to an article or QoTD without leaving a reason.  🙁  I thought this was a great question because of...

The rounding up of the last 30 seconds to the next hour is not a problem.

...

And as for space, if we have 100GB of data, then we have a...

Then you really, really need to make sure that security is as air-tight as it is in production and management needs to...

@Brandie...

The code at the following link, written by Jonathan Kehayias, has been a huge help on occasion.

https://www.sqlskills.com/blogs/jonathan/identifying-high-compile-time-statements-from-the-plan-cache/

As one example, one of the screens in an app that our folks wrote...

For any data you had to delete, anything with personally identifiable information, there are a couple of tools that can generate data for you to use in testing and...

It's not, IMHO, and I don't see anywhere in the thread above where that was...

As the OP want an opinion about the two code options presented, i.e.

Option 1:

DECLARE @strcol1 varchar(max), @intco11 int

SELECT @strcol1 += ','+CAST(col1 AS VARCHAR(20)),  @intco11=col1 
FROM...

I tend to write these things to allow any combination of values later, so I stick with individual checks.  For example, suppose later they want to check for status...

I'm not that worried about space per se. The column will be one of metadata and while seconds would be nice to have, accuracy to hours & minutes is...

I've been having debates with various tech people about ChatGPT. In many cases, it's not worse than the average (or below avg) dev. Not sure what to think of...