How to get this query working

Question

Post reply

How to get this query working

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Try something like this:

delete T1

from Table1 T1

inner join Table2 T2

on T1.Main = T2.Main

and T2.Type = 2

and T1.FullName = T2.FirstName + ' ' + T2.LastName;

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SQLFanatic SSCommitted Points: 1640 More actions · Answer 2

Thanks for your quick reply GSquared.

Yes, this will work. But, in the FullName field I have values like Ragan W Anderson and other values that will not be matched using concatenation operation.

Is there any way to use 'LIKE' operator here such as LIKE '%FirstName%'

Thanks,

________________________________________________________________
"The greatest ignorance is being proud of your learning"

GSquared SSC Guru Points: 260824 More actions · Answer 3

You could do this:

delete T1

from Table1 T1

inner join Table2 T2

on T1.Main = T2.Main

and T2.Type = 2

and T1.FullName like T2.FirstName + '%'

and T1.FullName like '%' + T2.LastName;

Put wildcards in where you need them. Might need one after LastName, if you have names that end in "Jr" or "III", etc.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SQLFanatic SSCommitted Points: 1640 More actions · Answer 4

Worked without a flaw.

I appreciate it man.

You saved me much needed time here. Was going haywire trying wildcards n stuff to figure this out.

Thanks again.

Have a very Good One !!

________________________________________________________________
"The greatest ignorance is being proud of your learning"

GSquared SSC Guru Points: 260824 More actions · Answer 5

You're welcome.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon