After you fix the updates and try the run (please let me know how that goes) again, then next thing I'd try to do is get rid of the While...

Yep... I found that undocumented alias form of update, too. While it seems to work quite well, you may not want to take a chance on it...

[font="Courier New"]...

Riga,

I'm still looking at the code but I did find a problem that's prevalent throughout the code where there are updates...

See anything wrong with the following code?

[font="Courier New"]-- Update all...

I think you're importing directly to the final table... why not import into a staging table and then you can do some validations and trimming before the data goes into...

Ummmm, so convert the result to a Bit datatype... all that is being returned are 1's and 0's... no -1's...

Just curious... the SIGN method with the subtraction from the ABS seems to work just fine as a negative number detector...

DECLARE @v-2 INT

SET @v-2 = -10

SELECT...

Do you still have the code for it?

No... but those can easily be added while excluding a...

You mean withing T-SQL? Sure... import the file... delete the desired rows... export the file. You could also write some VBS using the System File Object to do...

First, it would be a great help if you'd take a little time to post your data in a more readibly usable format so that we can actually write a...

... heh... and before anyone even thinks of suggesting ISNUMERIC, try this...

SELECT ISNUMERIC('$1000') UNION ALL

SELECT ISNUMERIC('1,000') UNION ALL

SELECT ISNUMERIC('3d2') UNION ALL

SELECT ISNUMERIC('2e3')

Obviously, that WHERE clause won't catch everything... but this will...

WHERE tblItem.strItem NOT LIKE '%[^0-9]%'

The circumflex (^) also means "NOT".

In other words, you will need to rewrite part of the app to use stored procedures instead of dynamic embedded SQL.

bodhilove (7/13/2008)

---

I have a table that has 1 field - email char(30). I am trying to bulk insert from a csv file. Some of the emails are bigger than 30...

Instead of writing to a text file, why not write to a table where each row has a "create date"?