Hola, tengo la siguiente consulta:
Código SQL:
Ver originalSELECT h.hora AS hora1,h.marca,h.codoptima AS codoptimaT,h.target,h.fecha AS hfecha,P.CODOPTIMA,O.CODIGO,
p.hora,p.peso,p.vaso,p.fecha,o.linea,o.tubo
INTO #tmp3
FROM pesos AS p, optimas AS o,htargets AS h
WHERE o.codigo = p.codOptima AND o.linea = 'L17S'
AND o.tubo = 'D' AND p.fecha >='20100628'
AND h.fecha >='20100628'
AND p.hora= '9:30 - 10:00' AND h.codoptima = o.codigo AND h.hora= '9:30 - 10:00'
SELECT *,(SELECT COUNT(1)total FROM #tmp3) AS totality FROM #tmp3
La ejecuto y me da los datos correctamente, ahora bien elabore un procedured pero este me da error, el procedured es:
Código SQL:
Ver originalSET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[monitor]
@fecha datetime,
@linea nvarchar(5),
@tubo nvarchar(5),
@hora nvarchar(15) AS
BEGIN
SET Nocount ON
SELECT h.hora AS hora1,h.marca,h.codoptima AS codoptimaT,h.target,h.fecha AS hfecha,P.CODOPTIMA,O.CODIGO,
p.hora,p.peso,p.vaso,p.fecha,o.linea,o.tubo
INTO #tmp1
FROM pesos AS p, optimas AS o,htargets AS h
WHERE o.codigo = p.codOptima AND o.linea = @linea
AND o.tubo = @tubo AND p.fecha >=@fecha
AND h.fecha >=@fecha
AND p.hora= @hora AND h.codoptima = o.codigo AND h.hora= @hora
SELECT *,(SELECT COUNT(1)total FROM #tmp1) AS totality FROM #tmp1
END
Al ejecutarlo:
monitor'L17S','D','20100628','9:30 - 10:00' me da el siguiente error:
Msg 8114, Level 16, State 4, Procedure monitor, Line 0
Error converting data type varchar to datetime.
Cual sera mi problema?