Here it is (for the problem #3 - but they are generated automatically so the are the same in all cases):

bcp [dbname].[dbo].[tablename] in "inputfile.dat" -c -C 1250 -t "|\t" -r...

There is one more issue with the procedure. If you look for example at the second statement:

UPDATE INVOICE

SET CUSTOMER_ID=SC.CUSTOMER_ID,SITE_ID=CUST1.SITE_ID

...

The same remarks apply to the second statement:

UPDATE INVOICE

SET CUSTOMER_ID=SC.CUSTOMER_ID,SITE_ID=CUST1.SITE_ID

FROM #JV_SACCODE SC,DBO.JV_INVOICE INV, DBO.JV_CUSTOMER...

Ananth,

You may expect that transaction adds some overhead to the procedure but appart from that I'm not sure whether the statements you use are correct.

If you look at the first...

Michael,

I'm currently working on application that copies data between SQL2K servers. It uses BCP. One of the large tables has 60 millions rows and it is imported into target database...

Francisco,

This is what I suggested but I'm still afraid that this query does not meet your business requierements. Isn't it that you need to retrieve all records that had status...

Francisco,

I'm not sure about the correctness of the query you posted. Take a look at the statement:

Select Distinct A.ccID, Min(A.ccDateTime) as ccDateTime, max(A.StatusID) as StatusID From HAAScc.dbo.tbl_ccStatus A Where A.StatusID...

Francisco,

I'm not sure whether the stored procedure that you posted before is still valid but it seems to me that it's not. In the procedure, the TELEMARKET part is commented...

I have still two ideas how you can improve the performance of the query.

1. Use the tbl_Contacts locally. You can do it by copying it to a local temporary table...

I usually look at the graphical representation of the execution plan available in Query Analyzer not only because I'm lazy but also because it displays more information than in the...

Tuning such stored procedures is what I do quite often for my customers. Looking at the stored procedure and its execution plan, I would do the following:

1. run sp_updatestats (already...

Thanks James,

Your answer was correct. This was a problem of missing unique index on the table from linked server. It means that the article from Microsoft applies not only to...