SELECT COUNT(*) FROM Invoice where InvoiceDate between '20210201' and '20210401'
SELECT COUNT(*) FROM SendBoxInvoice
SELECT COUNT(*) FROM SendBoxInvoiceLineType
SELECT COUNT(*) FROM SendBoxTaxSubtotal
SELECT * FROM SendBoxInvoice where  InvoiceDate between '20210301' and '20210401' and
InvoiceNo like 'PNR%' order by InvoiceNo

truncate table Invoice
truncate table SendBoxInvoice
truncate table SendBoxInvoiceLineType
truncate table SendBoxTaxSubtotal
--SELECT * FROM SendBoxInvoice where  InvoiceDate between '20210301' and '20210330' and InvoiceNo like 'PIN%' order by InvoiceNo

