amazing.  Yes works for what i need.  big thanks!

DROP TABLE if exists #testdata; 

--=============================
--Create test data table & Data
--=============================
CREATE TABLE #testdata
    
(
[freetext] varchar (200)NOT...

sorry - jumping around here.  You are right - its the 3rd argument.

enable_ordinal it doesnt support.

Sorry to waste people time 😔

Will leave question on forum may well be useful for...

Good point. It should be on 2017 forum.  Sorry about that. 😕

Microsoft SQL Server 2017 (RTM) - 14.0.1000.169

I did check after error & found when  split_string was introduced ... and...

Thanks.  This looks good.  Haddnt stumbled on split_string

When i run code on my machine it returns?

Msg 8144, Level 16, State 3, Line 27

Procedure or function string_split has too many arguments...

😂 yes i can only imagine a future with a resolution

This is a 1 off exercise outside of any UI to join some legacy data.  Im less worried about cost,...

Simple, effective and well written. Good stuff.  Thanks for sharing.

Do like this neat example of fixing file strings pre load.

Comes into its own when you have none (or limited) control over the Source data.

Good work well written!

This is perfect - seem slicker than a Trigger.
This is just the kind of reply i was looking for.
Many Thanks
Dan

Thanks for the comments. The July update solves the issue highlighted.

Fantastic to see Microsoft responding so quickly ;-)...

Excellent.

I will endavour to modify the NCI and update the ticket if any issues.

It still interests me as to why such similar queries can perform so differently.

Who knew the...

Thanks for your help Lowell

The NCI is on ResultDateTime and doesn’t include any columns.

The CI is on the PK which is partly the SourceID (+ 2 more fields)

The bit...

Great topic for me:-)

Just been scratching my head at same issue...

Msg 8985, Level 16, State 1, Line 1

Could not locate file *_log' for database 'I*' in sys.database_files. The file either...