ALTER PROCEDURE [dbo].[sp_invCargarArticulosNoContados]
(
	@codbod INT = 0,
	@FechaCierre DATE
)
AS
BEGIN
	-- Sumar un día a @FechaCierre
    SET @FechaCierre = DATEADD(DAY, 1, @FechaCierre);

	SELECT A.codbus,
	A.nomart, 
	A.codalt, 
	A.ubiinv1, 
	ISNULL(T.stock_logico, 0) AS stock_logico,
	0 AS stock_fisico, 
	0 AS stock_dif, 
	'False' AS contado, 
	GETDATE() AS fecha_toma, 
	@codbod AS bodega, 
	'False' AS contabilizado ,
	0 AS numlin,
	0 AS idPretoma
	FROM invArticulos A JOIN invStock S ON A.codbus = S.codbus AND S.codbod = @codbod
	OUTER APPLY (
			SELECT TOP 1 stockBodega AS stock_logico
			FROM (
				SELECT 
					stockBodega,
					fecdoc
				FROM invDetalle
				WHERE codbus = A.codbus
				AND codbod = @codbod
				AND fecdoc <= @FechaCierre

				UNION ALL

				SELECT 
					stockBodega,
					fecdoc
				FROM venDetalle
				WHERE codbus = A.codbus
				AND codbod = @codbod
				AND fecdoc <= @FechaCierre
			) AS Combined
			ORDER BY fecdoc DESC
		) AS T
	WHERE NOT EXISTS (	SELECT * 
						FROM invCierreTomaTemp C 
						WHERE A.codbus = c.codbus)

END