Jeff,

Sorry to bother you. You are the format file guru, could you please take a look at the new problem I have with BULK INSERT?

http://www.sqlservercentral.com/Forums/Topic622222-145-1.aspx

The problem is, the import doesn't fail - it simply sticks the next line into the 6th column (which is sufficiently large). So the only way to see that it...

I coudn't find a relevant example. Could you at least point me in the right direction?

We found in 2005 BULK INSERT wouldn't work when running under a Windows-authenticated account and importing from a UNC path. If you run under a SQL login, it should work...

I have a similar problem. How do you work around it with a format file?

Awesome query! Solved my headache today

The "i.id = t.id" in the WHERE clause is not needed because it's already in the join condition.

Since we are looking for primary keys and text fields cannot be part...

Jeff,

Thank you! That's an awesome hack you did with the leading and trailing quotes.

1) My server was barking on sysproperties table

2) Why bother creating a stored procedure if it's only reporting in the current database? A simple query would do

3) The Oracle-ish *=...

Speed. an INSERT is recorded in the transaction...

Jason,

I finally figured it out. The new table had an identity column, so bcp wasn't inserting garbage, it was simply renumbering my rows! Running SET IDENTITY INSERT NewTable ON before...

Adam Machanic liked a cursor-based solution for running sums:

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx

Do you have the same for SQL2005?

Do you have the same for SQL2005?

Is there any way to force the SP to run the set identity_insert command in the same session...