OK, I may be wrong on this, and feel free to correct me if I am, but isn't an Object type variable for holding results sets? You use it...

1. Full database backups should indeed be done regularly, although they won't make any difference to this situation.

2. Whether to shrink the log depends on whether it is expected to...

What data type is your variable StartDateTime? Why are you converting it to a datetime data type and then to a string data type?

John

Well, I don't think you have any choice. Data integrity is more important than performance. Experiment with temp tables, staging tables, outer...

Or, if the duplicates are definitely all within the text file (and not duplicates of data that's already in the destination table) then you don't need a lookup - you...

I think it's your quotation marks. You need a double quote at the beginning of the expression. You also need to make sure that all of the non-numeric parameters...

Something like this?

DECLARE @test-2 TABLE (a int, b int)

insert into @test-2 values (1,2)

insert into @test-2 values (2,1)

insert into @test-2 values (3,1)

insert into @test-2 values (4,1)

insert into @test-2 values (1,4)

insert...

You need to join back to your original table to get this. Something like this (not tested because you didn't supply any table DDL or sample data):

WITH LatestJob AS...

InfiniteError (8/19/2010)

---

what happen is that it updates the row randomly using there own value. like for example the original value of ID:1 is Amount=13230 but after random updates it become...

Is there a question here?

Everything you need to know has already been posted here - you just need to do a bit of reading. To summarise:

(1) Create a clustered index on all tables...

ashish.kuriyal (8/19/2010)

---

instead of shrinking your database regularly, you must redefine your full and log backup schedule.

You will definately see the difference.

if it still growing, then you need to find...

I won't go into why you shouldn't shrink your database - you can search this site and you'll find plenty of references. If you must do it, do it...

1. That's fine.

2. sp_helpdb

3. Don't shrink your database. If you need more space, add it. Are you performing regular maintentance on your indexes?

John

Enclose the column name in square brackets ([]).

John