Interesting that you mention Dataphor. There have been others that have been religous zealots about Dataphor...

That is a mighty big request, and there really isn't enough room here to fully answer what you have asked. One of the best things I could recommend is...

It would be better if you supplied the table and index information as DDL (CREATE TABLE and CREATE INDEX) statements. From your Excel spreadsheet it is a bit difficult...

Feel what? Variable names @d and @u may work in this example, but in a production environment it would not. There, variables and column names should have names...

Two things.

One, can you add a few more sample records that will cover all the cases you have described in your problem statement, for example, multiple transfers from the same...

honza.mf (11/18/2009)

---

Steve Jones - Editor (11/17/2009)

---

I have awarded back all points to people as of now. Apologies for the delay, but this was not the high priority of the day.

The...

Check out the following thread, it may help.

David Easley-401108 (11/17/2009)

---

I agree that the question is now better worded, but still disagree with the answer. Since the output of the queries is devoid of any timezone identification,...

Actually didn't get very far. I will admit to learning some things today. You'll find I spent a bit of time in the QotD world.

Almost time to get...

What you are attempting to do requires the use of dynamic sql. Please take the time to read about dynamic sql in BOL (Books Online, the SQL Server Help...

Paul White (11/17/2009)

---

Paul White (11/17/2009)

---

http://www.letmebingthatforyou.com/

(I...

I see that the question has been rewritten as it is now using variables that are set first and changes the word same to equivalent.

Now that the question has been...

christian.ain (11/17/2009)

---

I agree with all of you, most of us in the planet have to reply False since GETDATE() and GETUTCDATE() don't return the same value, except if you are...

Was this, assuming they all complete within the same second, always there? I don't even remember seeing it.

Nope, but I got the answer right without reading the discussion or running the code. I guess the force was strong...