Evil Kraig F (9/7/2012)

---

SQLRNNR (9/7/2012)

---

Lynn Pettis (9/7/2012)

---

Okay, an etiquette question as a Good Samaritan. How many times should you refuse money for helping a motorist with a disabled vehicle?...

SQLRNNR (9/7/2012)

---

Lynn Pettis (9/7/2012)

---

Okay, an etiquette question as a Good Samaritan. How many times should you refuse money for helping a motorist with a disabled vehicle? I was...

Okay, an etiquette question as a Good Samaritan. How many times should you refuse money for helping a motorist with a disabled vehicle? I was walking down to...

How about you start answering my questions first? A little rude to be asking more...

Andrew-495157 (9/7/2012)

---

The problem with the SP code is indeed the reliance on SQL implicit conversion. Easily fixed. Easily undersood.

The interesting issue is why, like many defects, it only emerged after...

Or maybe someone will write a client version of SSMS that meets this same need. Should be doable by some one who has excellent knowledge of SMO (isn't that...

Unfortunately my crystal ball is still broken, and since we can't see what you see there really isn't much we can do based on what you have posted.

What types of...

I do like the latest version. Looks like it should win the 1,000,000 row test.

The real test will be against a 1,000,000 (or so) table. I will try and set up such a test tonight at home. One of the things I...

I'm not sure if there is. However, if the user(s) do not have permissions to the other databases, they will not be able to expand those other databases and...

Sean Lange (9/7/2012)

---

I think is the one Lynn was thinking of.

http://msdn.microsoft.com/en-us/library/ms190309.aspx

Implicit conversions, which is what you have when datatypes don't match (like int and varchar) will always attempt to use...

Southeast side of Colorado Springs, just outside of Gate 20 to Fort Carson.

Andrew-495157 (9/7/2012)

---

@SSCertifiable

There is a consistency within SQL issue here which I don't understand

Why did the conversion NEVER fail with the value 'AB' is in the column?

This value has been there...

You may want to compare the execution plans between the two solutions provided:

CREATE TABLE #tblTemplates

(

...

Try this:

CREATE TABLE #tblTemplates

(

TemplateID int,

TemplateName...