/*[SP_Dispo_X_Leg3]*/

ALTER PROCEDURE [dbo].[SP_Dispo_X_Leg3]

@ano as nvarchar(4),

@mes as nvarchar(14),

@Lugar as nvarchar(2),

@press as nvarchar(1)

AS

DECLARE

@CodDispon as nvarchar(2),

SET @CodDispon ='99'

IF @press=1

BEGIN

SELECT DisPoS.* , ( DisPoS.ValTotDispo - ISNULL(Otes.saldoOT,0) ) AS SALDOD

From...