Thanks for letting me know that, How do I check that ?

The error messages are shown below as per request.

03/28/2018 15:37:43,test,Error,2,QSQL4TR,test,exec sp_send_dbmail,,Executed as user: ORG\mssql_service. Attachment file c:\backup\test.csv is invalid. [SQLSTATE 42000] (Error 22051)Unable to open Step output file....

Thanks Sue, I will try this out and let u know how it goes by tomorrow. Thanks for your help

Is there any format I should be using when invoking the  sp_send_email procedure. Do I need to have the permissions for my user account ?

I am not sure but looks like depending on the number of digits in cal value the final value is getting calculated, can someone let me know how to do...

Thanks ZZartin ur solution worked for me.
Drew, Thanks for your solution...

Just to add some more clarification to my question so people can understand reply me.
It appears that "Enc Reading" is supposed to represent a number (after all the processing...

I know SQL is not intended to do this but for sure there may be a way to do in SQL also.

Thanks for your suggestions, hope this table helps in explaining what  I am looking for.

yes actually my bad the rounding logic is to be applied to all cases but as you can see when there are leading zeros, the output is very different.

The logic is the same for all except that when there are leading zeros , it does not seem to work

Hi there,
  This works perfectly except for cases where there are leading zeros as is 0002125, I would like the output to be 213.000 instead its removing the leading...

Thanks this worked like a charm, appreciate your help.

Thanks for replying back,
I am using the following Query
select original_value,CONVERT(decimal(9,3), REPLACE(LTRIM(REPLACE("original_value"/10, '0', ' ')), ' ', '0')) AS decimal
and the output I am getting is shown...

Thanks everyone for your help, as suggested my SQL Server installation was not complete, I downloaded the SQL Server 2005 express edition from Microsoft'swebsite and this fixed the issue, I...