I'm struggling to find a better way to preserve the 2 digit precision for decimal variable....Here I have divided the question in 2 steps: ...Step1:...SQL Query...Inorder to get a 2 digit precision in a SQL query, I'm using ...CONVERT(DECIMAL(10,2), ....