Thanks. Got the desired result. I am calculating the average values for the column. I want to round this off to 3 digits. If I give the round function in...

If in this case I want to write an INSERT statement then how do I do that?

Thanks for the reply. Basically this is the format I will be displaying in the front end. I will be binding this data directly to the datagridview using a dataadapter....