It is hard to comment without knowing some more information about the table structures and how they are used.

1000 rows is not really a lot of rows for SQL server,...

use ROW_NUMBER ()

SELECT ID, userid ,

ROW_NUMBER() OVER (PARTITION BY userid ORDER BY userid) AS NewOrder

FROM rentalsTest

or as an update

update rentalsTest

set sortorder = NewOrder

FROM (SELECT Id, ROW_NUMBER() OVER (PARTITION...

Creating indexes would be a good start.

if possible simplify your join

using SSMS,

expand Security Group --> Right Click Schemas --> Create New Schema...

SET std_acc ='123456789' + CAST(@int_counter AS VARCHAR(9)),

this is the problem, why are you combining the data, if you state in...

Lots of new stuff,

the one I use the most is the new Date data type;

there is no longer the need to add an arbitrary time to date only records.

o/p = output ??

change the options to output the results to text file, then print from there.

Right Click in Query Window --> Results to --> Text

or save it...

As Matt said, check what database you are running this on.

Also I only wrote the SQL from the little information that was given, if you provide the table structures...

you can use the import/export wizards.

Right click on the database--> Tasks --> Import data.

Or write a sql INSERT statement and use the Three part naming convention for the table on...

I would have to disagree with trigeers,

set up PK->FK references in your database, and create one procedure to do the data manipulation as Kevin suggested.

That would be the best way of doing this.

instead of

and...

Or put the values that you need into a table and select them from there, will run more efficently and will be more scalable.

post here if you need any...

you are trying to convert a string that contains commas to an Int,

so it can not convert to an int.

strip them out.

Unless you are trying to covert each comma...

The value has the commas in the wrong place, strip out the commas and convert it.

you may also have to use the FLOAT data type as the result may...

I am a little confused,

how many rows are you dealing with in your tables?