We figured it out

there was a few empty values in that field, if we update to zero it worked fine.

thanks everyone!

thanks for answering everyone...

here's some sample data -

-95469.49

-92565.24

-90384.38

-89245.69

-88976.89

-88976.89

-82735.84

-82735.84

-79358.26

-78217.29

Sorry it doesn't have commas (my mistake)

so how do we handle the period?

okay...just so im sure about this before I talk to my boss...

the value from the vendor I'm importing is '584375.00000'

there's no way for me to change that to '5843.75' using...

well this is for an ssis package..and theres no data translation

so as a sanity check - I'm thinking they are sending us the data incorrectly because with scale I can...

MARKET VALUE 1MARKET VALUE DATE 1MARKET VALUE 2MARKET VALUE DATE 2MARKET VALUE 3MARKET VALUE DATE 3MARKET VALUE 4MARKET VALUE DATE 4MARKET VALUE 5MARKET VALUE DATE 5

1003/2/092003/3/093003/4/094003/5/095003/6/09

Hi Imu92,

I have...

I got it..it was in my expressions

I think I answered my own question...

select stmt_del_method, *

from rm_acct

---

where stmt_del_method = 'Print' COLLATE Latin1_General_CS_AS

--where rim_no = '1402809'

order by stmt_del_method

I think I figured it out...

thanks brandie...happy friday.

Thanks Brandie

When I go to grant the user access to the proc, I go to the proc, permissions, I hit objects and I see all my users, but not transactionuser...not...

Safe to assume, you've bounced the box?

it's not always bad to have overlapping indexes. They won't be used if they aren't needed.

But they will take up space.

Depeding on what type of transaction you can use 'bulk logging' or use SSIS to do your inserts (bulk).

You cannot disable logging completely in SQL.

You may want to post your...

I agree with the above steps...

but one other option..

you could always check ODBC on the client side...(if it's an MDAC based app)

Agreed.

Just looking for some outputs to prove DB is in good order....ie dbcc check db...or something similar...but that I can run on a prod box