Post the table schema and the columns you would consider in deciding if a row where a duplicate or not... there's hardly any reason to go to text files and...

Because of implicit conversions.

A better question would be...

... why are you copying INT data into an NVARCHAR column to begin with?

Yes, you do... but not in the code you posted... we can't tell which table hu_id is in.

Also,...

For starters, this....

WHERE CONVERT(VARCHAR, tblRFXProjecto.tmsCreated, 103) = CONVERT(VARCHAR, getdate()-1, 103)

... will not allow indexes to be used effectively because of the forced scan created by wrapping the column reference in...

I guess my question would be....

... what in blazes do you think you need to do in a database that can't be done in T-SQL?

The only possible exception to that...

Only way I can see that happening is if dbatools_filesize has two rows for each day for each database in it. Recommend you do a dupecheck to see...

Jesse McLain (2/11/2008)

---

I get a similar problem, but in the exact opposite way. When I run:

BULK INSERT Import

FROM 'C:\Import.txt'

WITH (FIELDTERMINATOR = '","', ROWTERMINATOR = '"', FIRSTROW=3522350, LASTROW=3522360, MAXERRORS =...

Heh... listen to what you just said... "it gets created... and then deleted WHEN...

What are the datatypes and, if appropriate, sizes for the 5 different columns you're pulling from, Greg?

That's normally the way I do it, too.

Absolutely perfect, Chris... I've always wondered why people try to do it the hard way.

Another way to do this is to simply have 2 tables and a view. While...

Craig,

This would be a lot easier to test code for if you provided some data and table schema info. See the following for how to do that effectively...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

First, since you don't have HU_ID in any part of your query, you need to tell us which table it's in.

Second, I think you also have dupes in the bcustomer_notification_call_list...

When you created the new xp's, did you make sure that you created them in the Master database?

Same subject... slightly different slant...

I, for one, would like to congratulate this fine community of professionals such as those witnessed in this thread. The subjects of auto-incrementing columns and...