dbo.sp_get_from_module_bc23_test

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO


-- =============================================
-- Author:
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE dbo.sp_get_from_module_bc23_test 
@car varchar(255) ,@username varchar(255) , @conn varchar(255), @dok_in_from_in varchar(54)
AS
BEGIN
    SET ANSI_NULLS ON
    SET ANSI_WARNINGS ON
 Declare @dynmaicsql as  nvarchar(1000);
 Declare @dynamicparam as nvarchar(1000);
 Declare @returnedcar as int
 
 --Microsoft.ACE.OLEDB.12.0
 Set @dynmaicsql = 
'set @car=(select count(*) from OPENDATASOURCE(''Microsoft.ACE.OLEDB.12.0'', ''Data Source='+ @conn +
'; Jet OLEDB:Database Password=MumtazFarisHana;Persist Security Info=False;'' )...tblBC23Hdr where CAR = '''+ @car +
''') '
 
 exec(
' SELECT [CAR] ,[KdKpbc] ,[Tujuan] ,[JnsBarang] ,[TujuanKirim] ,[PasokNama] ,[PasokAlmt] ,[PasokNeg] ,[UsahaId] ,[UsahaNpwp] ,[KdTPB] ,[Registrasi] ,[UsahaNama] ,[UsahaAlmt] ,[UsahaStatus] ,[ApiKd] ,[ApiNo] ,[PpjkId] ,[PpjkNpwp] ,[PpjkNama] ,[PpjkAlmt] ,[PpjkNo] ,[PpjkTg] ,[IndId] ,[IndNpwp] ,[IndNama] ,[IndAlmt] ,[Moda] ,[AngkutNama] ,[AngkutNo] ,[AngkutFl] ,[PelBkr] ,[PelMuat] ,[PelTransit] ,[BC23No] ,[BC23Tg] ,[KdKpbcBongkar] ,[KdKpbcAwas] ,[DokTupKd] ,[DokTupNo] ,[DokTupTg] ,[PosNo] ,[PosSub] ,[TmpTbn] ,[KdVal] ,[Ndpbm] ,[NilInv] ,[Freight] ,[BTambahan] ,[Diskon] ,[KdAss] ,[Asuransi] ,[KdHrg] ,[Fob] ,[Cif] ,[Bruto] ,[Netto] ,[JmCont] ,[JmBrg] ,[TglTtd] ,[KotaTtd] ,[Namattd] ,[ContakPerson] ,[NoPhone] ,[NoFax] ,[Email] ,[Status] ,[Snrf] ,[Lengkap] ,[PosSubSub] from OPENDATASOURCE(''Microsoft.ACE.OLEDB.12.0'', ''Data Source='+ @conn +
'; Jet OLEDB:Database Password=MumtazFarisHana;Persist Security Info=False;'' )...tblBC23Hdr where CAR = '''+ @car +
''' ')
END
GO