Are you SUUUUURE? I wouldn't want to play any favorites!! 😉

Thanks...

My pleasure, as always. I'd personally like a "You forgot yet another #%@#$ comma on line xxx." message.

Jeffrey Williams-493691 (9/22/2009)

---

I don't think the problem is the linked server, but the fact that you are not aliasing the tables. You can no longer use the full table...

Also, I would note that this is extremely basic error handling. You can do a lot more with it, like taking alternate paths, doing certain things based on the...

I changed it a bit from your failure example because you were attempting to cast 'null' as a date. This causes a syntax error, which is fatal. Your...

No shame intended...

With 2000, there is no TRY/CATCH, which means your error checking options are a bit more limited. You can use @@ROWCOUNT AND @@ERROR for simple checks, but depending on...

Ok, so I had to give it a go. I went ahead and tried to use what little I remembered (basically only that varbinary was involved and you used...

My pleasure, glad we could help.

I believe the character you might be looking for is ASCII character 19.

Try running something like:

SELECT * FROM YourTable

WHERE YourColumn LIKE '%' + CHAR(19) + '%'

And if I'm correct on...

The reason for N-1 all over my code is that my Tally Table starts at 1, where for the purposes of this, you need the first N to be 0....

Barry, I briefly tested dropping the index all together before inserting data into a temp table, but I'm not sure if that's fair since the index did in...

RBarryYoung (9/19/2009)

---

Garadin (9/18/2009)

---

And the results are in. It probably wasn't a fair contest to begin with. You were going up against a gut accustomed to eating 2 day...

Richard Fryar (9/18/2009)

---

My problem with the quirky update solution is the requirement to add a column to the original table, which may not be practical in reality.

I've got an alternative...

I don't believe the code run via OPENQUERY is parsed by the SQL server you are storing your SP on, so it wouldn't cause errors until you attempt to run...