Any chance there's an issue in the network between the 2 servers so that when you moved and were usign the process across both servers the nics may have been...

Could you not do this with either the full blown copy if you have one, or a demo copy of SQL compare http://www.red-gate.com/products/SQL_Data_Compare/index.htm or any of the other numerous data...

I take it adding validation to the current application/database is out of the question? It would seem more appropriate to be asking them to correct their data as soon...

Well I see this as having a couple of solutions. That depends on how this is going to be handled moving forward however, Is this a one time thing...

If you are looking to limit the records returned by a value or range of values, like your first example, you'd be able to do that in your where clause.

Select...

Can you be a bit more verbose with the type of errors you are looking for?

Are you looking to catch exceptions like divide by zero, or are you looking for...

I don't mean to be rude, but... Dates should be stored as dates, soring them as ints will...

It seems like the answer has been updated to show Rank() as correct, however It still says that I got it wrong even though I'm pretty sure I answered Rank()...

If you are logging the execution to a table in the database, then that table will be backed up along with the rest of your database. Also the execution...

You could upgrade to SQL server Std Edition and setup some replication. Std ed on one end as the publisher and SQL Express on the other end as the...

If all you want to know is that it competed successfully, you can explore the optiosn from the SQL Agent job, notification tab and have it send a mail on...

Career, who said anything about a career, that's a retirement plan 😉

Edit: It's all about finding a tax write off for my hobby 😉

Luke L (10/19/2007)

---

Well let's see, I started off with 2.5 years attempting a Sound Engineering Degree (The goal was to go work for Skywalker sound out on the Ranch) then...

Well let's see, I started off with 2.5 years attempting a Sound Engineering Degree (The goal was to go work for Skywalker sound out on the Ranch) then I lost...

with the clarification I understand what you're getting at now. Lowell's strategy is pretty elegant.

As for the temp table bit, yes, the system stores the table in memory for...