Hello Dear Mike,

I think we can also remove duplicates using simplest, easiest and better way without using temp table/s logic:

WITH CTE_InsurancePolicy AS (

SELECT PolicyId, FirstName, Surname, PolicyStartDate, PolicyEndDate

,ROW_NUMBER() OVER (PARTITION...

Dear in your first scenario it being returned 3 rows and in second scenario that will be returned 4 rows according to delimiter counting e.g. ‘bla;bla;bla;’ the last row will...