ChrisM@Work - Monday, December 11, 2017 9:57 AM
I have tested the above logic as Scalar & ITVF and it has good improvement. Below are the timings
================================================
========== Original Scalar Function ==========
Duration = 00:01:20:077
================================================
========== Improved Scalar Function ==========
Duration = 00:00:20:170
================================================
========== ITVF Function =====================
Duration = 00:01:51:150
================================================
========== Chris Scalar Function =============
Duration = 00:00:11:047
================================================
========== Chris ITVF Function ===============
Duration = 00:00:08:300
================================================
Thank you for the above link. Learnt something new today.