SQL Trick | How to Custom Sort Data | String_Split

[@Ivan-b9j3v]

Nice walkaround. Thank you! Now that I've read more about using '1' as a third argument for STRING_SPLIT I have better understanding of the algorythm used.

[@LearnatKnowstar]

Glad it was helpful!

[@andrewhofmann5453]

Great video! Also, this is STRING_SPLIT is not optimized for large sets, make sure to persist the output to a temp table and use that instead.

[@LearnatKnowstar]

Thank you