I have a sp that inserts payments made today from table account1
insert into
dailysales ([Date],CustomerID,InvoiceID,Payment ,PaymentType) SELECT Account1.Date, Customers.Name, Account1.CustomerID, Account1.Total, Account1.[Transaction] FROM Account1 INNER JOINCustomers
ON Account1.CustomerID = Customers.CustomerID WHERE (Account1.Date = DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)) select customerID,InvoiceID,Payment from DailySales RETURNUnfortunately it is inserting whole numbers insted of decimals. For instance if I enter 0.95 as a payment it inserts 1.00 into DailySales