How do I convert the 2 fields in this to money or decimal 2 . The results are not right as I think this is because both fields are FLOAT.
How do I convert them in the query to say MONEY or DECIMAL as 2 decimal places?
Select I.Invoice_Number, I.Items_Net, Sum(II.Net_Amount) Value,i.INVOICE_TYPE
From Invoice I
Inner Join Invoice_Item II on I.Invoice_Number = II.Invoice_Number
Group By I.Invoice_Number, I.Items_Net,i.INVOICE_TYPE
Order By I.Invoice_Number