You'll like this... takes just seconds to run on a half million rows... of course, you'll need to change #YourTable to your actual table name. For future...

I'll be right back...

That would be about right for 15M rows.

Just a bit of caution, though... make sure you follow ALL the instructions in the article. ...

On the flip side, you can get the machine name and maybe go from there...

SELECT HOST_NAME()

I can't help getting the feeling that was homework and the OP didn't try.

Micheal Young (1/8/2009)

---

Looking at Nitin's reply reminded me of a few coding things that can hinder performance (I'm basing this off my own experience).

1. If there are queries that use...

Why not just map a drive on each server and use the same drive letter on each server?

roy vagner (1/8/2009)

---

I have a table with 60 columns (most of the columns are int)

what is better for performance?

Leave the table like that or divide it for 2 or 3...

Either of the following will meet your requirements... 😉

SELECT MIN(RowNum)+1

FROM dbo.JbmTest

WHERE RowNum+1 NOT IN (SELECT RowNum FROM dbo.JbmTest)

SELECT MIN(RowNum)+1

FROM dbo.JbmTest...

gvsriramakrishna (1/7/2009)

---

Hi Mike,

Seems the query is taking a while to execute. I tried it for 20minutes.. not have seen any output.

Does this have any performance dependancy on the size of...

Chris Morris (1/8/2009)

---

Apart from anything else, the emphasis on teaching will give you quite a bit of leeway with the "give a man a fish" scenario. We've all been there,...

You were probably thinking about alligators, instead... 😉

eddy (1/8/2009)

---

if i try to run it now im not getting 2 rows with 3 prices each but i get 3 rows because the date filed is not the same...

You'll obviously need to reference table 2 more than once as if it were a separate table for User1 and User2 in table 1. To do that, just do...

eddy (1/8/2009)

---

Hi chrism,

Tnx this seems to work for the example,

Now i going to try to implement this with an update statement

my original temptable has this structure and i foresee...