Ok what I'm I doing wrong ;)
I've looked at the other posts on this subject and think I
have done everything right. But why I'm I still getting
decimals such as 10.40 and 23.50 , being returned from my
stored procedure as 10.4 and 23.5 ! Values such as 10.44
are ok, it just seems to be values with a zero at the end.
My table has the field defined as DECIMAL (18,2). When I
view the table in SQL Enterprise manager it also shows the
value without the last zero ! I thought the whole point of
defining a SCALE of 2 was to in effect fix the decimal
places to 2 ?
Even in my Stored Proc I have the following SELECT
CAST(invoice_amt AS NUMERIC(18,2)) AS invoice_amt,
...and I still get 10.4 and 23.5 returned !!!
Please help ;)