Hi,
I have column called "label" having datatype numeric(8,2).
I am trying to run an update statment as follows on that column as follows
label=(datepart(day,rndtime-startime)*24+
Datepart(hour,rndtime-startime)*60+
Datepart(minute,rndtime-startime)/60)
I am getting an error numericoverflow while running the update statment
when I update the datatype of the column "label" to numeric(9,2) the update works without any errors.
Since I would not like to change the datatype if the column can anybody suggest how to identify the values in the label column which is execeeding and is the main reason for the error?