You need to fix the example you posted.  You tried to obfuscate some information with a Magenta Marker but it was actually a hiliter and we can read the data...

With the understanding that I've not done any deep analysis on any of the code posted and going only on what I've seen in the past, the nested REPLACEs that...

Thanks for the feedback, Kazoo!  I appreciate it.

(Sigh...)  My apologies, folks.  I spent a couple of hours manually color coding all of the code because I knew the "code windows" on this site makes a bit of...

First things first... ALWAYS read the Microsoft Documentation on such things.  Here's the link so there's no excuses on the prime duty of a DBA...

https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql

Second, look at the options......

I checked the link in the response and got "Malicious Site Blocked" warning and so hit with the spam button.  And, yea... I subscribed to the original post as soon...

Great question, Steve.

Another hint here is that there's nothing to guarantee the order within any given rank.

Heh... along with what the others posted, another possible answer is "Interview Question" 😉

Ok... that's roughly the same query you've posted two other times.  It's not nice to cross post.  Stick with one thread on something like this.

And why on Earth are you convert IDs to VARCHAR(MAX)?

So is it a text or image file or a combination or??? What kind of file is it?

Sorry for the confusion. Yes, as the data stands right now the entire column should be populated with an *. If the department column included 0001 and 0002, then...

Hi

I  have data like below. Brands can be dynamic

Loc1            Brand          Qty        Value

Loc1           ...

Thanks for the feedback, Kenneth.

You mean you set your alarm on to go off on a Saturday morning 😀 😀 😀

I won't bore you with how...