IF IndexProperty(Object_Id('Val_Tarjetas_Lotes_Items'), 'IX_TARLI_PorTransEst', 'IndexID') IS NOT NULL	
DROP INDEX [IX_TARLI_PorTransEst] ON [dbo].[Val_Tarjetas_Lotes_Items]
GO

ALTER TABLE Val_Tarjetas_Lotes_Items ALTER COLUMN Importe DECIMAL(20,2)
ALTER TABLE Val_Tarjetas_Lotes_Items ALTER COLUMN Importe_2Vto DECIMAL(20,2)
ALTER TABLE Val_Tarjetas_Lotes_Items ALTER COLUMN Importe_3Vto DECIMAL(20,2)

CREATE NONCLUSTERED INDEX [IX_TARLI_PorTransEst] ON [dbo].[Val_Tarjetas_Lotes_Items]
(
	[Id_Trans] ASC,
	[Estado] ASC
)
INCLUDE ( 	[Id_Cliente],
	[Nro],
	[Descripcion],
	[Importe],
	[Nota],
	[Cuit],
	[Fecha_Est],
	[Importe_2Vto],
	[Importe_3Vto]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO