DECLARE @Date VARCHAR(8) = '20240101', @Group VARCHAR(MAX) = '00100A,00110H' --'0012GB,001360,00192P'--001AES,001281,001ECL,001VHS,001BPE' --@ShowCaptive INT = 1 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED DROP TABLE IF EXISTS #PRODUCTS, #GRP, #GrpBillExt, #BillAdjst, #TPREM_BillAdjst, #EEBILLF...