kevmck (7/30/2012)

---

Basically - I need to match the person to the tier based on some user defined rules. These rules would be along the lines of tier 4 is...

Are you trying to figure out which tier a person should belong to? In other words this sounds like you are trying to write a GetPersonTier function or something like...

Abu Dina (7/30/2012)

---

Thanks for this Sean. You are right about the badly written query but for now I'm trying to work out if the approach adopted by the previous developer...

Well of course but it was rather fun to write in...

Performance on this is going to be awful. You where clause is full of non-SARGable predicates.

It seems you have a number of duplicated checks in each pass too. You join...

create function IsPalindrome(@String1 varchar(100), @String2 varchar(100))

returns table

return

(

select Case when @String1 = REVERSE(@String2) then 1 else 0 end...

eric.rini (7/29/2012)

---

For example a physical authentication like linking an account to a mobile phone (it sends u a text with a unique key to login) or using a token like...

The best thing you could do is to read the first link in my signature. It will give you best practices on posting questions.

Sweet!! 😀

Alright Jeff, thanks! Im here back at the office and I am trying to change the loops into the code you have given me. I cant seem to understand how...

Yeah, that's what I meant. 😉

That will certainly fix the ability to call this but the real issue here is the code itself.

To the OP. Some might actually consider it a good...

If it was a trigger then you seriously need to fix that trigger to handle multiple row statements. Don't just work around the...

I can't speak for anybody else but I was not. Knowing Lynn and Jeff as well as I do...

Lynn Pettis (7/27/2012)

---

Sean Lange (7/27/2012)

---

Jeff Moden (7/27/2012)

---

Tell them what you told me in the email you sent...