Any open ideas please?

Thank you in advance

Please see below sample data

insert into #MyPhoneList values (123456789,'King@travel.com',null,'b.king@gmail.com',0,0,1,1,0,1)

insert into #MyPhoneList values (234567891,'drew@cocacola.com','drew@cocacola.com',null,1,1,1,1,0,1)

insert into #MyPhoneList values (345678912,'bob@chase.com',null,'kuya@gmail.com',1,0,1,1,0,1)

insert into #MyPhoneList values (456789123,null,'cmith@aix.com','bbc.king@gmail.com',1,1,1,1,1,1)

insert into #MyPhoneList values (567891234,'Kate@walmart.com','boxwe@yahoo.com','simb.king@gmail.com',1,1,1,1,1,1)

insert...

Hello

Thank you for your inputs

Nolock is ignore the locks (please ignore it)

sure i will provide the sample data soon

i mean accountid is primarykey, in table

Thank you,

Dhani

Hi Jeff,

i just comeup with ssn its actually an account holder unique id just for firm, i am working for major pharma industry

hope this helps

Best Regards

MIla

Could somebody please help me, any ideas please...

Thank you very much Eiriksson,

Thank you for your response Eiriksson

Sorry for the Confusion,

to make it simple,

--#list table has a composite primary key on (AcctID, email ,Segment)

--Drop table #list

CREATE TABLE #LIST (AcctID numeric, email varchar(20),Segment varchar(20), Addr1 varchar(20), City...

Thank you Lous i appreciate your help, greatful to you

sorry again, in a big stress, please excuse me

Hope this may help you,

create table #check1 (Segment varchar(3),balance numeric, deptno int, acct int,SetColumn int)

Insert into #check1 values('SEG',7000,300,5656,NULL)

Insert into #check1 values('SEG',4000,500,5656,NULL)

Insert...

Sorry,

A table called pptList it has 500k rows, 7 columns

out of these 7 columns, we need to work around on 5 columns

which is

1) Segment column has 3 values SEG,MOR,CLN

2) Balance...

Hello Thank you for your reply,

just want to know any otherway to do this,

also would like to know effecient way to do it

Thank you

Dhani

Hello Chris,

Thank you very much, its the answer, I greatful to you,

Thank you to all, who tried to helped me, Thanks a ton

by the way it is VeryVoted a segment...

Hello Good Morning,

Thank you for your input, it has bit issue with results, that is completely my wrong, i haven't explained well in my earlier post, sorry for this.,

i hope...

Hello could anybody please assist with this

Thank you in advance

Please

could you please help me here,

am i doing anything wrong here with this below query i am just getting null in first column

select

case

when a.MasterKey IS not null and...