I have a table sequence field real data type.
we save sequencenumber.two digits year like 99999.17
now right after 99999.17, when we pass 100000.17 , it is getting saved in table as 100000.2
Is there any issue with real data type. we are passing numbers
100000.17 > becoming 100000.2 in table
100001.17 > becoming 100001.2 in table
kindly need help, trying to run manual update query to set the value to 100000.17, still going back to 100000.2
sql server 2008 R2 on windows 2008 server
Thanks a lot for the helpful info.