Thanks for the reply. Do you have any other ideas for a solution to my problem?

Could I use stored procedures instead of functions perhaps?

Can a I make a stored procedure...

Thanks for the input!

I will try Views and Table Variable and see if any of them are possible solutions.

Yes I have indexes on all Primary keys ( as default by SQL server ). And the primary keys are the columns that I use to link tables together.

The query...

Uhmm quite large/complex but simplified they look like this:

ObjectTable (2 millions)

Uniqueidentifier, int, int, varchar(50),int, int, varchar(50) etc. mostly 200 columns.

PermissionTable1 (2 millions) Each object has one row in this table

Uniqueidentifier,...

Thanks for the advice.

I tried Bulk Insert using a little test application and I will probably manage to insert my data in hours instead of weeks.

/Joel

Umm to clarify my last post.

ORDER must be used to be sure.

I only tried to explain that you have to have ALOT of rows to find that out in tests...

In my query ,in which I had one clustered index, It returned the same order EVERY time until i had more than 98.000 rows returned. After that I got random order.

Thanks for the answers,

I forgot to add the ORDER BY clase I realised that

Still strange that I didn't get the data in order...

Humm nevermind, I found the problem.

My Query didn't return the rown in the same order every time. Doh.