Good luck with your question then.

You have LOG scales instead of LINEAR. LOG scales must be positive, they cannot be negative or even zero (it's a math thing).

Also the "zero point" of a LOG...

Well, I am not proficient with LINQ, but in T-SQL, we would do it like this:

Select COALESCE(DropOffDate, DeliverDate) as MergedDate

From order

Order By MergedDate

Assuming that your blank date fields are...

Same thing, AFAIK.

You could put a Key on the table (Primary Key, Alternate Key/Unique Index) to prevent this. That is what they are for.

Are there any other process that are writing to these tables at the same time?

Although multiple Select's should not normally deadlock, I would certainly think that it was possible for...

Try Event Viewer.

That should work.

My guess would be that something is different/wrong with the content of the two columns. Please post the CREATE TABLE definition for the table and some INSERTs...

I am completely lost. Is SQLClue a product? And this article is a product review? Who makes it then?

Yes, there is a way to do this, but you should not do it. In fact you should not being using this approach at all: Using Recursion as a...

What were you using (client-wise) to execute this code? This appears to be a problem with...

A SSIS package does not have to be scheduled through SQL Agent, it can run on it's own entirely outside of SQL Server.

As such you can schedule it...

I would suggest running the SQL Server 2000 to 2005 Migration Assistant on this...

leonp (2/23/2009)

---

what could I have done better (or not done bad) to get more responses??? not sure if this would get any responses .. but if it does, it'll be...

Agreed. I don't disagree with the Surface Area principle (Use less and Disable what you aren't using) to minimize exposure, it's one of the core principals of modern computer...