QUERY: arUtilizar Sum con un campo nvarch

[Former Member]

Buen dia, tengo un duda, como hago para realizar esta consulta

SELECT T0.[ItemCode] AS 'REFERENCIA', T0.[ItemName] AS 'DESCRIPCION', T1.[OnHand] AS 'SIN MEC', T2.[OnHand] AS 'MEC', SUM(T7.[Quantity]) as 'PEDIDO', SUM(T3.[Quantity]) AS 'ENTRADA CAM' , SUM(T5.[Quantity]) AS 'CAMBIO', sum(T5.[U_HPORO])

FROM OITM T0

INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode AND T1.[WhsCode] = 'MTPRIM'

INNER JOIN OITW T2 ON T0.ItemCode = T2.ItemCode AND T2.[WhsCode] = 'PTENSM'

LEFT JOIN WTR1 T3 ON T0.ItemCode = T3.ItemCode and T3.[WhsCode]='MTDFCTPR'

LEFT JOIN OWTR T4 ON T3.DocEntry = T4.DocEntry AND T4.Filler='MTDFCT'

LEFT JOIN WTR1 T5 ON T0.ItemCode = T5.ItemCode and T5.[WhsCode]='MTPRIM'

LEFT JOIN OWTR T6 ON T5.DocEntry = T6.DocEntry AND T6.Filler='MTDFCTPR'

LEFT JOIN PDN1 T7 ON T0.ItemCode = T7.ItemCode

LEFT JOIN OPDN T8 ON T7.DocEntry = T8.DocEntry

GROUP BY T0.[ItemCode], T0.[ItemName], T1.[OnHand], T2.[OnHand], T3.[WhsCode], T4.[Filler], T5.[WhsCode], T6.[Filler]

en el SELECT se encuentra el campo sum(T5.[U_HPORO]), pero T5.[U_HPORO] es un campo nvarchar y me genera error. Como hago para convertirlo en numerici¡o y que me sume?

[Former Member · Accepted solution]

Hola...

Revisa si te es posible utilizando la sentencia CAST

sum(CAST(T5.U_HPORO AS INT))

, si no es posible, entonces me temo que debes evaluar la posibilidad de actualizar o crear nuevamente el campo con definición numerica.

Saludos Cordiales,