WITH SampleData2 (PERSONNUM, [ORGPATHTXT]) AS
(
    SELECT 231089,'./Company/20-00001/120---30-00006/40-00506/50-99506/60-29145/97455001/0097455001/Fire-Grill'
     UNION ALL 
    SELECT 121564,'./Company/20-00001/120---30-00006/40-00073/50-00075/60-26275/68990001/0068990001/Location3/Burger-Cook'
     UNION...

If you think it will be faster using a seek then just force the query to do a seek and see if it's faster

select ol.ord_no, pl.ID
 ...

I generally never put error handling into a stored procedure unless I want to take some specific action inside the stored procedure for that error. If an error is raised...

There are some caveats to that should've been mentioned.  The string is declared as NVARCHAR(MAX) because I don't know that that's not appropriate.  The ordinal splitter is name...

1. Rebuild your non-unique non-clustered indexes that have NOT been disabled.  Rebuild them from smallest to largest.
2. Rebuild your previously disabled non-clustered indexes from smallest to largest.
3. Rebuild your...

Here's a way, though it would be pretty stupid to do it.

SELECT x.CustomerID
  FROM (SELECT c.CustomerID, 0 Col1
        ...

Maybe they meant using a set operator. In which case you would use EXCEPT not UNION.

SELECT c.CustomerID 
  FROM [Customers] c
EXCEPT
SELECT o.CustomerID 
  FROM [Orders]...

Yes, I see why now, the join on the update query returns more...

Other than using dynamic SQL I think you will have to do it like this:

In 2 statements

UPDATE s
   SET s.Col1 = s2.Value
  FROM #sample...

• This reply was modified 4 years, 1 month ago by Jonathan AC Roberts. Reason: changed s2.Value to s2.ColName

I don't understand how adding a column can add rows.

Can you show us the code?

Is the table clustered on ID?

Have you got any other indexes on the table?

Have you looked at the execution plan?

As we don't know what the processing is no one will be able to say whether or not a DYNAMIC READ_ONLY CURSOR is the best way to process your data. Can...

Yes, the ROW_NUMBER() function is unused so does nothing.

What error are you are getting?

SELECT BusinessEntityID, 
       FirstName, 
       MiddleName, 
       LastName, 
...