I have a table with Results column (data type = float) and a DecDigits Column (Data type = smallint). I need to creat a view to show the results column according to the DecDigits column for example:
Results = 0.1256 with DecDigits = 2 ==> in View to show Results = 0.13
Results = 3.6 with DecDigits = 0 ==> in View to show Results = 4
Results = 3.14 with DecDigits = 1 ==> in View to show Results = 3.1
Can anyone help?