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