dbo.spu_insertbc25

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE PROCEDURE dbo.spu_insertbc25
(@id_sa_hdr bigint, @username varchar(50), @BC25No varchar(100), @BC25Tg date )
AS
BEGIN
  if (select COUNT(*) from dbo.tbl_sa_hdr  where id_sa_hdr=@id_sa_hdr)< 1
  begin
  select '06' as status, 'Data Tidak Ditemukan' as description
  return   
  end
  declare @NPWP_PEMBELI varchar(50)
  declare @NAMA_PEMBELI varchar(50)
  declare @jmlinv int
  set @jmlinv = (SELECT     COUNT(*) AS cnt
  FROM         (SELECT     COUNT(INV_NO) AS Expr1
                       FROM          tbl_sa
                       WHERE      (id_sa_hdr = 1)
                       GROUP BY INV_NO) AS derivedtbl_1)
  
  select top 1
  @NPWP_PEMBELI = NPWP_PEMBELI,
  @NAMA_PEMBELI=NAMA_PEMBELI
  from dbo.tbl_sa
  where id_sa_hdr = @id_sa_hdr
  
  update dbo.tbl_sa_hdr set BC25No=@BC25No,BC25Tg=@BC25Tg, update_by=@username  where id_sa_hdr=@id_sa_hdr
    
  select '00' as status, 'BC25 PROCCESSED' as description   
 
END

-- MERGE Products AS TARGET
 -- USING UpdatedProducts AS SOURCE
 -- ON (TARGET.ProductID = SOURCE.ProductID)
 -- WHEN MATCHED AND TARGET.ProductName <> SOURCE.ProductName
 --OR TARGET.Rate <> SOURCE.Rate THEN
 --UPDATE SET TARGET.ProductName = SOURCE.ProductName,
 --TARGET.Rate = SOURCE.Rate
 -- WHEN NOT MATCHED BY TARGET THEN
 -- INSERT (ProductID, ProductName, Rate)
 -- VALUES (SOURCE.ProductID, SOURCE.ProductName, SOURCE.Rate)
 -- WHEN NOT MATCHED BY SOURCE THEN
 -- DELETE
 -- OUTPUT $action,
 --DELETED.ProductID AS TargetProductID,
 --DELETED.ProductName AS TargetProductName,
 --DELETED.Rate AS TargetRate,
 --INSERTED.ProductID AS SourceProductID,
 --INSERTED.ProductName AS SourceProductName,
 --INSERTED.Rate AS SourceRate;
 --SELECT @@ROWCOUNT;
GO