Had similar issues with reseeding "virgin tables". Key is that last_value in Sys.Idnetity_Columns is "null" for a virgin table, and not zero as one would have thought. The script below...

Sorry, some of the details got lost in translation or in my attempt to simplify the problem for this post (The original Query's size is about 25k).

Thanks for your help.

Ok, I found the problem.

This is problably the reason why one should rather provide the complete query and not extracts.

There is floor function being used on...

Hi, Thanks for the post. The tables already have composite indexes on the fields which is used in the where/join clause of the query.

I've found something that might be causing...

Ok, I posted a reply, but it failed for some reason, so lets try again.

Basically, tableB is Sales, and TableA is a Punctuation Table. The idea is when a cashier/waiter...

Hi,

I had the same problem when I switched from SQL2K to SQL2K5. I replaced the IN/Subquery part with an EXISTS statement, and it worked perfectly.

select * from TableA

where NOT EXISTS

(...

Ok, that is probably the better way of doing it.

Probelm solved.

Thanks for your help.

Hi,

The query is takes payments and invoices, and then check what allocations has been done against them. The allocations is [transaction type] 35, and exists in the same table ([Debtors...

Hi,

I am currently using attaching the database with the single file method ('sp_attach_single_file_db'). Does the "WITH MOVE" work with this stored proc? I can't get the syntax right

Thanks for your reply.

Hi Jay,

Are you using SQL or Windows authentication and named pipes or TCP/IP?

Robert

Please post that script, I'll give it a try.

Thanks

Thanks, this seems a whole lot easier.

I am using T-SQL, but this sounds interresting. If I understand correctly, you'll use a ado recordset and using the addnew/update functions, the autonumber value will be returned?

I'll give it a...

Thanks,

Thats a good idea, but i have multiple workstations posting entries at undetermined times. I guess adding a workstation ID to my table will be a solution. Then I could...

Hi.

Looks like some usefull info.

Thanks

Robert