Hi all,

I have a table w/ 50 mill. rows. I need to update 2 columns. The table
looks like:


patientrcd# patient# facility subtitle datetime page
-------------------------------------------------------------------
0202013 23432 B 05/17/0402 NULL 1
0202013 23432 B 05/17/0402 NULL 2

I need to :
1. 'NULL' subtitle column (varchar)
2. Populate datetime colum with a date from another database

note: there are no identity columns

Is there any way to leverage DTS to do the job? OR do I have to find a
way to break the data down into chunks and write multiple 'UPDATE' stmts?

I'm new to DTS, so just wondering....

TIA

Hello ChristinaO,

If the database is simply a database on the same server then the action i
think you will need to perform is as simple as an UPDATE statement with 3
part naming

<database name>.<owner name>.<object name>

Performance is based on indexing if this is a searched update.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan,

Thank you. Yes, they live on the same server. When I've tried to dojust
that, I ran out of locks. I'm not sure how to get around it?


Allan Mitchell wrote:

Hello ChristinaO,

You ran out of locks?

How many was that?

Have a look here

http://www.sql-server-performance.co...n_settings.asp

Are statistics up to date?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Idakno. Mybe I'm crazy. heh

Stats are definitely up to date. I run full scans nightly.

Let me try to run the update again. So the information/problem is fresh.

Thanks again Allan!
Chris

Allan Mitchell wrote: