Viewing 15 posts - 49,171 through 49,185 (of 59,065 total)
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...
July 14, 2008 at 10:11 pm
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"]...
July 14, 2008 at 10:00 pm
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...
July 14, 2008 at 9:51 pm
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...
July 14, 2008 at 5:22 pm
Ummmm, so convert the result to a Bit datatype... all that is being returned are 1's and 0's... no -1's...
July 14, 2008 at 2:23 pm
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...
July 14, 2008 at 2:17 pm
GilaMonster (7/14/2008)
Actually, I did suggest ISNumeric, with the warning that it's not perfect. Does your like allow for - and .?
No... but those can easily be added while excluding a...
July 14, 2008 at 8:00 am
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...
July 14, 2008 at 7:57 am
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...
July 14, 2008 at 6:51 am
... 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')
July 14, 2008 at 6:46 am
Obviously, that WHERE clause won't catch everything... but this will...
WHERE tblItem.strItem NOT LIKE '%[^0-9]%'
The circumflex (^) also means "NOT".
July 14, 2008 at 6:44 am
In other words, you will need to rewrite part of the app to use stored procedures instead of dynamic embedded SQL.
July 14, 2008 at 6:39 am
bodhilove (7/13/2008)
July 14, 2008 at 6:32 am
Instead of writing to a text file, why not write to a table where each row has a "create date"?
July 14, 2008 at 6:30 am
Viewing 15 posts - 49,171 through 49,185 (of 59,065 total)