Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --發票請購
- select A.StartNumber,A.EndNumber,A.InvoiceUseNum,B.InvoiceDate,B.BuyApplyId ,B.HasCashRegisterInvo,A.InvoiceWordTrack,C.RequestMethod,A.CU_DeptId
- from medGetUseInvoice A
- left join medInvoiceBuyApply B on A.BuyApplyId=B.BuyApplyId
- left join medMediaRequestParam C on A.CompanyId=C.CompanyId
- where A.CompanyId='05076416' and A.InvoiceUseOrder=1
- And A.CU_DeptId ='' and B.InvoiceId='35' and (201809 between A.UseBegDate and A.UseEndDate)
- Order by B.InvoiceDate ASC,A.InvoiceWordTrack ASC,A.StartNumber ASC
- -- 最大號
- Select Distinct 0 as IsInvalidateInv,Max(A.InvoiceNo) AS InvoiceNo,A.BuyApplyId
- From MedSellInvoiceMsg A
- Where A.BuyApplyId= @V0 AND A.CompanyId= @V1
- AND Exists(Select * From medGetUseInvoice ZA Where A.CompanyId=ZA.CompanyId
- AND A.BuyApplyId=ZA.BuyApplyId AND (201809 BETWEEN ZA.UseBegDate AND ZA.UseEndDate)
- AND RIGHT(A.InvoiceNo,8)>=ZA.StartNumber AND ZA.EndNumber>=RIGHT(A.InvoiceNo,8) AND ZA.InvoiceUseOrder=1) AND A.BillNo<>@V2
- Group By A.BuyApplyId',N' @V0 varchar(255),@V1 varchar(255),@V2 varchar(255)',@V0='201809-001',@V1='05076416',@V2=''
- exec sp_executesql N'Select Distinct 1 as IsInvalidateInv,A.InvoiceNo,A.BuyApplyId
- From MedSellInvoiceMsg A Where A.BuyApplyId= @V0 AND A.CompanyId= @V1 AND Exists(Select * From medGetUseInvoice ZA
- Where A.CompanyId=ZA.CompanyId
- AND A.BuyApplyId=ZA.BuyApplyId AND (201809 BETWEEN ZA.UseBegDate AND ZA.UseEndDate)
- AND RIGHT(A.InvoiceNo,8)>=ZA.StartNumber AND ZA.EndNumber>=RIGHT(A.InvoiceNo,8) AND ZA.InvoiceUseOrder=1)
- 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