Thank you Scott. is there any way we can do it with out temp tables,. I am trying this in snowflake so just checking to see if we can do...

Hello Phil,

Sorry My mistake. here is code for ddl some dml samples , Can you please help. Thanks

CREATE TABLE STUDENTIDPOOL (
    ID INT IDENTITY(1,1)...

Dear Phil Good Morning,

I have id  columns which is autoincrement in the table LEGACY.STUDENTIDPOOL already which is unique value

can you please give statement if possible. Thank you much

I am trying this one Phil, as I have 1 million some how the OR clause taking too much time

---------------------------------------------------

DROP TABLE IF EXISTS #Grouped;

DROP TABLE IF EXISTS #AllEmails;

DROP TABLE IF...

Good Morning Phil.

That is correct phil, it is assigning unique groupid for each customer. that has matching emails customers as well. Apologize for delay in response. Thank you for helping...

Dear Phil Morning,

Here I split the code loaded in temp tables but here in output I see groupid getting 1 for all customers.

What I am trying to do is combined...

Actually let me rephrase the question is there any way can I do with temp tables by splitting it each set I think union taking to much for my process...

Thank you Phil. You the best one quick Q for you, I have data about 1 mill plus so in this case any ideas how to reduce effect of it...

I mean in addr & city the combination has to match.

also please not all columns values are nullable so some times there is missed values in fields

Thank you Phil.

Ok great. please  with email first then phone nos second  then addr&city (combined) last

please let me know if you need any more info. Thank you

That is correct Phil, Yes, I change my mind about customer being in more than one group. based on it can you please help. Thank you

Thank you Phil, great advise.

Sure I will try that. Can you provide some code based on data provided. and No to below question. please

Can the same customer be in more...

Thank you So much Phil. for your efforts.

I got it bit tricky, but we are ok to generate using temp tables or CTE etc. I tried the query but since...

You are correct, Yes Phil that is correct. it can be possible.

i tried this a day back but not moving any direction, no luck from my end, can you please...

Dear Phil Good Evening

Please let me know if you need any more information, Thank you