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...

Heh... I love instant confirmation! Thanks, Chris!

Yep... and that "simple self join" is classified...

That's kind of what I'm thinking... doesn't take much extra time...

Could it be that simple? Your original post said you added an extended sp called "xp_add" yet in your latest post you say you are using "xp_add1". Do...

John Beggs (2/11/2008)

---

I don't know why I didn't think of this last week, but the problem (in my case) was in the database compatability level. I was working in...

Print commands, like rowcounts, can sometimes be made to bubble up through the app.

However, I agree... I prefer to use Raiserror properly rather than the likes of PRINT......