This is I actually don't mind... but this is one way you guys get paid, so I'm glad this is fixed ;).

Thanks, how did you fix a few 100 artices that quickly?

Thanks. I'm not used to Ajax apparently ;).

You call Halo 3 a big week-end??

It took your 4yo son 2 days to make it. You should be able to knock that out in 8-10 hours.

:hehe:.

Tomm Carr (9/28/2007)

---

The problem with using the Replace string function is that 10.341 ends up as 1034100 if the numeric is defined with five places. If you want 10.342 to...

Cancel that, I'm having a great day, this is why I came up with this solution :

declare @i decimal(10,5)

Set @i = 1078.734

PRINT REPLACE(@i,'.','')

--What's needed? 107873400 or 1078734

Set @i =...

Playing Devil's Advocate >>

You think it's better to keep 2-3-4 more columns in the base table for the original insert, then copy all that data everytime something gets updated into...

For dropping leading and trailing 0s from the string. Maybe I just missed the problem altogether...

Must be having a bad day or something.

He's not having any troubles... it's just the other 2-3 programmers who are having a hard time :hehe:.

Wow, 52 gig of space!!!! That's a lot of crap to put up with ;).

I think every member should get a free full summit pass for next year. That would be a hell of a casino party ;).

I was not pointing fingers at anyone... I was just wondering if that knowledge was as wide spread as I taught.

This should do the trick... 100% of the time :

DECLARE @val DECIMAL (11,8)

SET @val = 100.10300100

SELECT REPLACE(RTRIM(LTRIM(REPLACE(REPLACE(CONVERT(VARCHAR(30), @val), '.', ''), '0', ' '))), ' ', '0')

SET @val = 0.01

SELECT...

DECLARE @MYDECVAR DECIMAL

DECLARE @MYINTVAR INT

SET @MYDECVAR = 100.123

SET @MYINTVAR = CAST(@MYDECVAR AS INT)

SELECT @MYINTVAR

This returns 100, not 100123 as it should.

As suggested by someone else. DROP SMO ALTOGETHER. You have to do all of this manually if you want performance. Believe I've been there.