That is Correct Phil.

so when ever the phones matches (any customers any phone nos ) then assign one generic no.

if email 1 or email 2 matches with any other customer...

Good Morning Phil, Yes I am expecting GroupID, Custno columns.

there is no order for example one customer email1 matches with another customer email2 or email 1 they all considered one...

Please see code in code block

CREATE TABLE #Customers1 (Custno int, Addr1 varchar(50), City varchar(50), Res_Phone varchar(15), Bus_Phone varchar(15), Fax_Phone varchar(15), Marine_Phone varchar(15), Pager_Phone varchar(15), Other_Phone varchar(15), email1...

I did this now my temp table has data from 2006 to 2112 about 36k records. Thanks

-- Create a table variable to hold the date range

DECLARE @StartDate DATE, @EndDate DATE

SELECT ...

Good Morning Ali,

Thank you much for clear explanation, I am getting error "Msg 467, Level 16, State 1, Line 2

GROUP BY, HAVING, or aggregate functions are not allowed in the...

Thank you , Got it Des.

Best Regards

Thank you very much Des

Thank you Very Much Jeffrey Williams, I will dig in more details of the patindex and charindex. Thank you both Again

I tried Charindex (Name: ) and Charindex(Sal:) then seond - one but no luck yet 🙁

Please help me. Thank you

Good Morning,

For time being I manual replaced for .INC and LLC etc where ever there is commas 🙂 as temporary fix we good here. Thank you for your support.

this is...

Actually you are correct. I see very few other fields has , in between values such as Name: John, Doe, Age:30

so I am trying to get rid of commas if...

Thank you Phil.

There is no control in the history data which is what I am working on 🙁

So here what I am thinking is Replace commas in the  WCO: value...

Dear phil,

I am thinking first replace comma with space or empty  in the WCO string, then apply the logic

Thank you

Z Sita

Got it Great! Thank you phil, one last question for this one

so here the value (example below record) "WCo:Underwriters at Lloyds, London" it is splitting the Underwriters at Lloyds ,...

Thank you much Phil, I tweaked little hear and there your first code is working great. may I know what is this 8k 4k apart from String Split function? please

I...

Good Morning Phil,

I have few issues I am encountering that is just my wrong data your solution is great.

Can I ask you a quick question, is there anyway can we...