Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    16

    Unanswered: Totally stuck with money, Please help!

    i'm using query analyzer,

    simply trying to use smallmoney as

    In my table I have declared as:
    payrate smallmoney,

    Inserting values into table like this:
    '258'

    Error recieved is:
    Disallowed implicit conversion from data type varchar to data type smallmoney,

    What am I doing wrong? Also, ideally i'd like the 258 to be expressed as 258 (english pounds) if anyone can help with that also.

    Thanks in advance

  2. #2
    Join Date
    Jan 2004
    Posts
    1

    Re: Totally stuck with money, Please help!

    Hi!!
    I am new to this so I really don't know whether this will solve your problem.....but aren't you supposed to enter the value without quotes???

  3. #3
    Join Date
    Dec 2003
    Posts
    16
    thanks mate

    didn't spot that!

    it's given me values in english pounds as well, i'm guessing thats because of my system settings?!

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    it's given me values in english pounds as well, i'm guessing thats because of my system settings?!
    Yeah .. you can change these settings through control panel ... regional settings.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    And I thought you needed a loan... :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •