sql server – “Error converting data type varchar to numeric.”
When implementing a similar solution I get the following error:
Error converting data type varchar to numeric
My variable id is as numeric and variable name is as varchar, and I want to show the name instead of the id
Tables:
SELECT TOP (1000)
[codigo],
[descripcion] varchar,
[fecha_ingreso] datatime,
[valor] numeric,
[stockMinimo] numeric ,
[codigo_bodega] numeric (10,0)
FROM
[Bodega].[dbo].[Articulo]
SELECT TOP (1000)
[codigo] numeric (10,0),
[descripcion] varchar (30)
FROM
[Bodega].[dbo].[Bodega]
Query:
SELECT
articulo.codigo,
articulo.fecha_ingreso,
articulo.valor,
articulo.stockMinimo,
articulo.codigo_bodega
FROM
Articulo
LEFT JOIN
Bodega ON Articulo.codigo_bodega = Bodega.descripcion
I want to show the descripcion but not the codigo
Read more here: Source link
