BULK INSERT would work ok, if the file name was consistent. With the file changing then it probably wouldn't be ideal, and I'm not sure you're be able to archive...

Considering that your images don't seem to tie anything together, this is very difficult to tell you anything. What is the SQL you are running. What is the Sample data?...

How are you defining which ID needs to be updated with which URL?

Ok, this does seem like it's going to be quite complex. I think I have an idea (or two), but it's going to take a bit to really set up...

Images aren't really helpful here. You need to paste your SQL and upload your .sqlplan file.

Considering that you're changing, what seems like every url to the same thing,...

This isn't cascading anymore, this is one parameter selects all the others.

I think, because you haven't really defined your question in a post, things are getting missed as...

This is not valid SQL:
SELECT CityID,
 CityName
FROM DevtestDB.dbo.City
WHERE CountryID = @Country1, @Country2, @Country3 ... @Country7
The reason for that set up in that example was...

This still sounds like cascading parameters. Did the topic i linked to above not help you on this matter? This shows how you can limit the parameters based on a...

One possible problem I could see is if your business opening hours change. Is this likely, and if so, how would you cater for it?

Duplicate of topic: https://www.sqlservercentral.com/Forums/1870160/export-data-to-Excel-using-sql-stored-procedure

Please only create one topic per question, as you'll get better answers and discussions.