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.

Got me there. I have barely just enough experience with SSIS to spell it. I was hoping it would give you some inspiration, but apparently not.

I'll leave this...

Is there still someone who doesn't know that it's pointless to update a row without doing any change (like in your exemple)??

That should be thaught in DB 101.1!

Just one question on that Jeff. How do you track the information of When, what, who inserted the original row?

I know this data should be kept separate from the...