Thank you for the code Jeffery, that worked perfectly and thank you to everyone else for your input

Jeff,

Thanks for the script to create the function but unfortunately I can not add it onto the server

Each row does have a PK, I just didn't add it to the...

Unfortunately, I can not use DelimitedSplit8K as I can not add functions on the server and I keep getting "'string_split' is not a recognized built-in function name." when I try...

Here is the code of the script.

create table #ACME (TreePath nvarchar(max))

insert into #ACME(TreePath)
values('ACME products,Outdoor Equipment,Outdoor Accessories,Outdoor Accessories Shelter')
insert into #ACME(TreePath)
values('ACME products,Outdoor Equipment,Outdoor Accessories,Outdoor Accessories Skin Care')
insert into...

Standard week is Sunday to Monday.

My mistake, I'm trying to get the information to get the correct value that will place the results into a date table that I have,...

Thanks to everyone for the assistance