greg eze (4/2/2009)

---

To make use of RPC, I will definitely have to turn off the fire walls of those machines,we have them turned on by default. That's where the security...

Both "Ping Pong Ball" and "Elephant" have...

Glad I could help.

I have found one case where it matters, but it is obscure. That is, when executing generated script that are rare case when SQLCMD or a query window executing...

Use sysprocesses or sp_who or the Activity Monitor to look at the CPU & IO stats for the process and see if they are changing or not and if the...

Oops, and I see now that this is for SQL 2000. Now I would say that your approach is the best... I must be getting tired...

Hmm, I confess that I had missed your second table there.

And now I see that we are including the column headers as extra rows in the output. ...

Is it consuming resources or is it just waiting? If the later, then it is probably blocked and probably by you or some other DBA having the Table Design...

And watch out for that first step, it's a doozy!

The clauses that appear in the WITH section are just definitions. The server does not do anything with them until they are invoked in the SELECT section.

I think that a better question is "Why would you want to do this?"

The importance of this question that you are implying that the columns are interchangeable and that is...

jsanborn (4/2/2009)

---

>>No, it is the same as the 3, null, 9, situation, mathematically. A later value in a later column is higher than an earlier value in an earlier column.<<

It's...

Heh. Wow, am I embarrassed. :blush:

Right, Bob, this is a "Shift Left When Zero" sorting problem. I realize that that description is inferior to the one given by the OP, but we are inferior...

Like this:

Select * From first F1

Where Date IN (Select MAX(Date)

From first F2

Where F2.id = F1.id

And...