That'd be a good plan.... make 'em do the work for you... then show 'em why it wasn't a good idea to start with... then they would stop ignoring your...

k.. then you're on your way... Good luck with this project.

Well why r they asking you to merge the tables??

Are they asking you to take an apple and an orange table to make a fruits table. Or to take...

Unless you are calling extremely complexe stored procs from within that 2nd cursor, I don't see why you could just make a series of inserts/deletes/udpates. Can we hear a...

Ya Select top 25 PERCENT * from dbo.YourTable order by Newid()... Would be even faster than everything else we suggested. Th eonly problem is that the 25% couldn't easily...

Wow... must be some kick ass server you got there.

Thanx for the timing.

How long does it take to run that query a a few M rows?

Hey Frank I'll have to tatoo those D@mn unequal joins someday because I never think about using them... Fortunately for me, this time the subquery runs about 3 times faster...

Also keep in mind that this query uses the the clustered index for the order by (implied), you might have to tweak the indexes or the query to achieve the...

I didn't test it but since there's no create table / insert then I assume it's gonna be faster... But then again 1000 rows is not that mayny.

Same logic applied without using a temp table :

--whole table

Select id, name from dbo.SysObjects O1 order by id

--1st, 5th rows....

Select id, name from dbo.SysObjects O1 where (Select count(*) from...

I'll repeat what Allen, SA23 and Tony have already said. The problem is not sql server, it can handle 600 000 transactions / minute if the server is strong...

Can you post it here so that others can benefit from your efforts?

Yes, don't use a cursor...

What r u trying to accomplish in this task?.. maybe there's a set based solution for your problem.

This is the statement generated by EM

ALTER TABLE dbo.AVT_FACTMA_Impayees ADD CONSTRAINT

FK_AVT_FACTMA_Impayees_AVT_FACTMA FOREIGN KEY

(

FFNOFACT_INT

) REFERENCES dbo.AVT_FACTMA

(

FFNOFACT_INT

) ON UPDATE CASCADE