selamat siang gan,
mohon bantuanya...

ane punya script ini,

SELECT TH.[Receipt No_ 2] AS [Receipt No.],
CONVERT(VARCHAR(10),TH.[Date],110) AS [Transaction Date],
CONVERT(VARCHAR(24),TH.[Time],108) AS [Time],
NPH.No_,
ICA.[Description] AS Category,
PRODG.[Description] AS [Sub Category],
FUNC.[Description] AS [Function],
SUBFUC.[Description] AS [Sub Function],
MASB.[Description] AS [Master Brand],
BRAN.[Description] AS Brand,
TSE.[Barcode No_] AS [Barcode No.],
TSE.[Item No_] AS [Item No.],
ICA.[Description] AS [Description],
TSE.[Unit of Measure] AS UOM,
CAST(-TSE.Quantity as decimal(10,0)) AS [Sales Qty],
CAST(TH.[Payment] as decimal(10,0)) AS [Total Sales Excl.PPN],
CAST(-TH.[Net Amount] as decimal(10,2)) AS [Total Sales Excl.PPN]

FROM [Catur Mitra Sejati Sentosa, PT$Transaction Header] AS TH
INNER JOIN [Catur Mitra Sejati Sentosa, PT$Trans_ Sales Entry] AS TSE
ON TSE.[Store No_] = TH.[Store No_] AND
TSE.[POS Terminal No_] = TH.[POS Terminal No_] AND
TSE.[Transaction No_] = TH.[Transaction No_]
LEFT JOIN [Catur Mitra Sejati Sentosa, PT$Nota Penjualan Header] AS NPH
ON TH.[Receipt No_ 2] = NPH.[Receipt No_]
INNER JOIN [Catur Mitra Sejati Sentosa, PT$Item] AS I
ON TSE.[Item No_] = I.No_
AND TSE.[Item Category Code] = I.[Item Category Code]
INNER JOIN [Catur Mitra Sejati Sentosa, PT$Item Category] AS ICA
ON I.[Item Category Code] = ICA.[Code]
INNER JOIN [Catur Mitra Sejati Sentosa, PT$Product Group] AS PRODG
ON I.[Product Group Code] = PRODG.Code
INNER JOIN [Catur Mitra Sejati Sentosa, PT$Function] AS FUNC
ON I.[Function Code] = FUNC.Code
INNER JOIN [Catur Mitra Sejati Sentosa, PT$Sub Function] AS SUBFUC
ON I.[Sub Function Code] = SUBFUC.Code
INNER JOIN [Catur Mitra Sejati Sentosa, PT$Master Brand] AS MASB
ON I.[Master Brand Code] = MASB.Code
INNER JOIN [Catur Mitra Sejati Sentosa, PT$Brand] AS BRAN
ON I.[Brand Code] = BRAN.Code
WHERE TH.[Receipt No_ 2] > '0' AND
TH.[Date] BETWEEN '2015-10-01' AND '2015-10-13'
GROUP BY TH.[Receipt No_ 2] , TH.[Time], TH.[Date],NPH.No_, ICA.[Description],
TSE.[Item No_],ICA.[Description],TSE.[Unit of Measure],TSE.[Barcode No_],
TH.[Payment],TH.[Net Amount],TSE.[Item Category Code], PRODG.[Code], PRODG.[Description],
SUBFUC.[Function Code],FUNC.[Description], FUNC.[Code],
SUBFUC.[Description], MASB.[Code], MASB.[Description],
BRAN.[Master Brand Code], BRAN.[Description],TSE.[Quantity]

hasilnya ada nullnya


biar hasilnya

gimana ya gan ?