The screenshot of your query has part blanked out, but I assume that that is a declaration of a database, so you are using 3 part naming convention, rather than...

That does seem to be similar to the structure i provided above. Does that not give you something to start off on?

My guess would be that the error you got was "XML parsing: line 9, character 13, unexpected end of input"? This is because your xml is malformed.

Your xml...

Is anyone other than myself still having problems when pasting to SSC? I'm getting a little "fed up" with having to realign my text in the post reply box every...

We really need a bit more in depth detail on your set up, however, I would hazard a guess that a hotel can be used in many tours, and also,...

Do you mean you're looking for SP's on your database/Server where they use the WAITFOR command? You could use something like Redgate's SQL Search add on (which is...

Do you have the query plans. Those are the really important part here, if you're estimates are off.

How often do you run these delete statements? Do you also...

Having the estimated rows being off can be a problem yes, as it'll often mean that not enough resources are allocated to run the statement. This normally then means that...

You have mssql for Visual Studio code as not Cross Platform, but I can confirm that it very much works on Ubuntu 16.04 (and I imagine Mac/Docker as well).

You could use the Delimited8KSplit. Then it becomes as trivial as:

SELECT DS.Item
FROM YourTable YT
     CROSS APPLY dbo.Delimited8KSplit (YT.YourColumn, '/') DS
WHERE DS.ItemNumber...