If there are multiple items, how are they returned? Is this a text stream, or are these separate rows being returned? The output is a datatable/result set of some sort,...

Need to do some weekend work since I'm a bit behind and I leave for a week next week. Flying Monday, so not much of a holiday. Especially with some...

If that's all you have and can't write code, then:

declare  @top varchar(1000) = 'MATERIAL-Matl01',
            @last  varchar(1000) = ''
while @result is not...

Adding answered isn't a bad idea.

My short list for the vendor right now is getting the forum name listed in searches, because the title isn't enough.

I'll...

Hmmm, if we changed the color of the thread, how do we determine answers? I know we could pick a new color, but contrast and colors don't always make sense....

Yep

Well, keep in mind that NoSQL has meant "Not-Only-SQL" for some, and "Not (relational) SQL" for others.

Your indentation doesn't make sense from a db perspective. Are these separate lines? a separate table of data? What is a demand, and what does "top" mean? Is this ordering...

I'm not sure what your issue was exactly from the description. I have a 2014 instance and the default data, log, and backup folders are moved to the e: drive....

As Steve noted, your terminology makes no sense from the outside. We don't know your business, so the Supply Mtl Tag and demand have no context. We'd need some explanation...

I've been hesitant to purchase items outside of food for companies, since it's easy for some bosses to just decline the expense.

We once lost an admin password...

Fair points, David. Certainly simpler coding might be a benefit that makes sense for the development side, even if performance were similar (or worse).

I thought  SQL 2017 had ...