hello...
i want to create a table named 'caustic_batch_tank'
containing following columns
1.empcode varchar(50)
2.shiftid int
3.edatetime datetime
4.tagval
i want to assign datatype to 4.tagval to decimal but the floating-point of tagval column may be on unit place,tenth place, hundred place,thousand place,thenth thousand place etc.
i had used float but it didn't work any more.
plz help me.
values for tagval
0.235,
256.368,
7856.3698,
2.3698,
12.258,
123.1
etc