Nothing like a bit of PPTS.  Can't help but watching.

Heh......

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