so there's no way to move the decimal via precision/scale?

Thanks man

I chnaged some things now I'm getting a

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Thanks

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?