How to convert int to decimal procedure SQL

Question

I have this proc

[...]
BEGIN
  SELECT ODMI.VLR_LABOR AS Labor,
         O.ID_ODM AS IdODM,
    FROM ODM O
    JOIN ODM_AREA_IMPACTO ODMI ON ODMI.ID_ODM = O.ID_ODM
    JOIN AREA A ON A.ID_AREA = ODMI.ID_AREA
   WHERE O.ID_ODM = xx

END

Labor is a decimal in c# code.
How to convert ODMI.VLR_LABOR to deicmal at the time of execution of the procedure.

I try CONVERT(DECIMAL(16,4), height/10.0) AS HeightDecimal but not success.

it seems that the comma after `AS IdODM,` should be removed. — Dmitry Bychenko, Dec 03 '15 at 13:10
Where possible you should consider using CAST over CONVERT. See this question for more: http://stackoverflow.com/questions/707335/t-sql-cast-versus-convert — David Rushton, Dec 03 '15 at 13:17

score 1 · Accepted Answer · edited Dec 03 '15 at 13:16

1

You use variable height but it doesn't exist in your code. Try this:

BEGIN
  SELECT CONVERT(DECIMAL(16,4), CONVERT(DECIMAL(16,4), ODMI.VLR_LABOR)/10.0) AS Labor
         O.ID_ODM AS IdODM
    FROM ODM O
    JOIN ODM_AREA_IMPACTO ODMI ON ODMI.ID_ODM = O.ID_ODM
    JOIN AREA A ON A.ID_AREA = ODMI.ID_AREA
   WHERE O.ID_ODM = xx

END

edited Dec 03 '15 at 13:16

Mukesh Kalgude

4,814
2
17
32

answered Dec 03 '15 at 13:10

Maxim Goncharuk

1,285
12
20

score 1 · Answer 2 · answered Dec 03 '15 at 13:13

1

SELECT
    CAST(ODMI.VLR_LABOR * 1. / 10 AS DECIMAL(18,4)) AS Labor,
    O.ID_ODM AS IdODM
FROM ODM O
JOIN ODM_AREA_IMPACTO ODMI ON ODMI.ID_ODM = O.ID_ODM
JOIN AREA A ON A.ID_AREA = ODMI.ID_AREA
WHERE O.ID_ODM = xx

answered Dec 03 '15 at 13:13

Devart

119,203
23
166
186

How to convert int to decimal procedure SQL

2 Answers2