Does the sql Admin user (the user that starts the sql service) have permission on the folder that you moved the files ?

Try the following

select * from table1 where id not in (select id2 from table2 where isnull(id2,'') <> '' )

Use Odbc connection.

It's about 4 times faster.

Do you use oledb connection or ODBC ?

I must export the data just the way they imported. The one that sents me the file has to pefrorm the group by and order clause.The question is how can...

There is an aggreement specifying the grouping of the file, thus all groups must be together and in order.

I guess you have an account that starts the sql server service.

Does that account have "read" permissions on the folder that contains either the .mdf or .ldf files ?

Why not session_user ?

I've already done it using union and cursor but is there any other faster way to do so ?

Thank you.

Yes why not? Let me check it.

Thanks.

Ok I solve it

Thanks.

Hi thanks for your respond.

I don't want to group by and count those fields i want the one field to become 3 by splitting the rows dividing by 3

In my...

Thanks a lot.

That's exactly what i was looking for.

Maybe i confuse you

i create a table that have the followinf fields

Zip CountPerZip

12345 5

23456 ...

I have already done it but how will i add x times the zip code at the produced splitted columns?