CREATE procedure SP_MP_Fact_MigraCompras_XML
@Ind001 float,@Ind002 float,@Ind003 float,@Ind004 float,
@Ind005 float,@Ind006 float,@Ind007 float,@Ind008 float,
@Ind009 float,@Ind010 float,@Ind011 float,@Ind012 float,
@Ind013 float,@Ind014 float,@Ind015 float,@Ind016 float,
@Ind017 float,@Ind018 float,@Ind019 float,@Ind020 float,
@Ind021 float,@Ind022 datetime,@Ind023 varchar(50),@Ind024 varchar(50),
@Ind025 varchar(50),@Ind026 varchar(50),@Ind027 varchar(50),@Ind028 varchar(50),
@Ind029 varchar(50),@Ind030 varchar(50),@Ind031 varchar(50),@Ind032 varchar(50),
@Ind033 varchar(50),@Ind034 varchar(50),@Ind035 varchar(50),@Ind036 varchar(50)
AS
set nocount on
insert into Tb_Fact_Compras(
[Com Total Todo Pesos],[Com Total MN],[Com Total ME],[Unidades Totales],
[Cancelacion Todo Pesos],[Cancelacion MN],[Cancelacion ME],[Unidades Canceladas],
[Devolucion Todo Pesos],[Devolucion MN],[Devolucion ME],[Unidades Devueltas],
[Notas Todo Pesos],[Notas MN],[Notas ME],[Descuento Todo Pesos],
[Descuento MN],[Descuento ME],[Compra Bruta Todo Pesos],[Compra Bruta MN],
[Compra Bruta ME],[FECHA-ID],[EMPR-ID],[INVARTI-ID],
[VENOART-ID],[INVAD1A-ID],[INVAD2A-ID],[INVAD3A-ID],
[INVAD4A-ID],[INVAD5A-ID],[INVALTE-ID],[COMTPRO-ID],
[COMOPRO-ID],[COMAD1P-ID],[COMAD2P-ID],[COMCIUP-ID])
values(
@Ind001,@Ind002,@Ind003,@Ind004,
@Ind005,@Ind006,@Ind007,@Ind008,
@Ind009,@Ind010,@Ind011,@Ind012,
@Ind013,@Ind014,@Ind015,@Ind016,
@Ind017,@Ind018,@Ind019,@Ind020,
@Ind021,Convert(Datetime,@Ind022),@Ind023,@Ind024,
@Ind025,@Ind026,@Ind027,@Ind028,
@Ind029,@Ind030,@Ind031,@Ind032,
@Ind033,@Ind034,@Ind035,@Ind036)
set nocount off
GO