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...

And what you told...

Holy cowabunga. Over there on the left when posting is IFCode shortcuts. They do a great job of helping format large code segments.

The real problem is that the code you...

Sean Lange (7/27/2012)

---

J Livingston SQL (7/27/2012)

---

Sean Lange (7/27/2012)

---

OK now we all have the same code to work from. Nice job posting readily consumable ddl and sample data. What I don't...

J Livingston SQL (7/27/2012)

---

Sean Lange (7/27/2012)

---

OK now we all have the same code to work from. Nice job posting readily consumable ddl and sample data. What I don't understand is...