Advertisement
Guest User

Untitled

a guest
Apr 10th, 2019
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.65 KB | None | 0 0
  1. --發票請購
  2. select A.StartNumber,A.EndNumber,A.InvoiceUseNum,B.InvoiceDate,B.BuyApplyId ,B.HasCashRegisterInvo,A.InvoiceWordTrack,C.RequestMethod,A.CU_DeptId
  3. from medGetUseInvoice A
  4. left join medInvoiceBuyApply B on A.BuyApplyId=B.BuyApplyId
  5. left join medMediaRequestParam C on A.CompanyId=C.CompanyId
  6. where A.CompanyId='05076416' and A.InvoiceUseOrder=1
  7. And A.CU_DeptId ='' and B.InvoiceId='35'   and (201809 between A.UseBegDate and A.UseEndDate)
  8. Order by B.InvoiceDate ASC,A.InvoiceWordTrack ASC,A.StartNumber ASC
  9.  
  10. -- 最大號
  11. Select Distinct 0 as IsInvalidateInv,Max(A.InvoiceNo) AS InvoiceNo,A.BuyApplyId
  12.  From MedSellInvoiceMsg A
  13.  Where A.BuyApplyId= @V0 AND A.CompanyId= @V1
  14.  AND Exists(Select * From medGetUseInvoice ZA Where A.CompanyId=ZA.CompanyId    
  15.  AND A.BuyApplyId=ZA.BuyApplyId AND (201809 BETWEEN ZA.UseBegDate AND ZA.UseEndDate)        
  16.  AND RIGHT(A.InvoiceNo,8)>=ZA.StartNumber AND ZA.EndNumber>=RIGHT(A.InvoiceNo,8) AND ZA.InvoiceUseOrder=1) AND A.BillNo<>@V2
  17.  Group By A.BuyApplyId',N' @V0 varchar(255),@V1 varchar(255),@V2 varchar(255)',@V0='201809-001',@V1='05076416',@V2=''
  18.  
  19. exec sp_executesql N'Select Distinct 1 as IsInvalidateInv,A.InvoiceNo,A.BuyApplyId
  20. From MedSellInvoiceMsg A Where A.BuyApplyId= @V0 AND A.CompanyId= @V1 AND Exists(Select * From medGetUseInvoice ZA
  21. Where A.CompanyId=ZA.CompanyId        
  22. AND A.BuyApplyId=ZA.BuyApplyId AND (201809 BETWEEN ZA.UseBegDate AND ZA.UseEndDate)        
  23. AND RIGHT(A.InvoiceNo,8)>=ZA.StartNumber AND ZA.EndNumber>=RIGHT(A.InvoiceNo,8) AND ZA.InvoiceUseOrder=1)
  24. AND A.BillNo= @V2',N' @V0 varchar(255),@V1 varchar(255),@V2 varchar(255)',@V0='201809-001',@V1='05076416',@V2=''
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement