I also figured out the swapped parameters. Great solution!

Your bad-char look-up table takes zero milliseconds like Jeff's and mine. But your version needs only one logical read instead of 4...

Next thread will be yours 😛

Obviously you're not enjoying the Holiday the old-fashioned way... Neither do I...

Paul, did you try your code? If I execute it I get "A & B Cleaners" as result.

Hi David

Did you try ISDATE?

DECLARE @t TABLE (MyDate VARCHAR(100))

INSERT INTO @t

SELECT '0200-07-30'

UNION ALL SELECT...

Hi Conan

Enclose your SQL with "code" tags:

[ code ]

SELECT * FROM Blah

[ /code ]

... without the spaces will...

GSquared (5/1/2009)

---

Florian Reischl (5/1/2009)

---

I would say it was a...

Phil Factor (5/1/2009)

---

With the prettifier, you get the option, but I wrote it originally just to get SQL Code into blogs that only allowed FONT tags. However, it was very...

Jeff Moden (5/1/2009)

---

Maybe it's just me and I'm thinking of the wrong person. ...

Jeff Moden (5/1/2009)

---

Almost forgot... the reason why I don't use the code windows anymore is because, although they may work fine with FireFox, they suck when using IE7. The...

Hi Mohit

Please have a look to Gail's blog about optional parameters:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Greets

Flo

Hi

Splitting the work into batches is a good approach! I would handle it in one step with a WHILE loop (this is not RBAR 😉 ). Take your first batch...

Hi

I cannot reproduce this error. I just copied your statement, pasted to SSMS and executed on my AdventureWorks. No errors.

Greets

Flo

Well... This the third thread now.

It becomes annoying!

If you have further questions answer to your initial thread here

As you wrote in the other thread the "spaces" are CHAR(0) and CHAR(10). So use REPLACE to remove them.

Greets

Flo

Duplicate post. Please answers here:

http://www.sqlservercentral.com/Forums/Topic708326-338-1.aspx