INSERT INTO tDataCollection
(SequenceNo, ServiceID, BatchID,
 TxnDate, TxnTime, Origin,
 Duration, CallCode, RateDescription,
 FromDate, ToDate, TransactionTypeID,
 AmountExGST, GSTAmount, GSTFlag, AmountIncGST,
 RevenueFlag, Var01, Var02, Var03, Var04)
SELECT tDataCollection.SequenceNo, tDataCollection.ServiceID, tDataCollection.BatchID,
 tDataCollection.TxnDate, tDataCollection.TxnTime, tDataCollection.Origin,
 tDataCollection.Duration, tDataCollection.CallCode, tDataCollection.RateDescription,
 tDataCollection.FromDate, tDataCollection.ToDate, tDataCollection.TransactionTypeID,
 DC3.AmountExGST, DC3.GSTAmount, DC3.GSTFlag,
 CAST((DC3.AmountExGST + DC3.GSTAmount) AS money) AS "AmountIncGST", (1) AS "RevenueFlag",
 tDataCollection.Var01, CONVERT(varchar,DC3.Cost,2) AS "Var02",
 CONVERT(varchar,DC3.AmountExGST,2) AS "Var03", ('0.15') AS Var04
FROM (SELECT DC2.*,
 CAST((CASE WHEN DC2.GSTFlag LIKE 'Y' THEN (DC2.AmountExGST * 0.1) ELSE 0 END) AS money) AS "GSTAmount"
FROM (SELECT DC1.DataCollectionID, DC1.Cost,
 (CAST(tDataCollection.Var01 AS Integer)*Cost) AS "AmountExGST",
 (CASE WHEN DC1.CustomerID = 449 THEN 'N' ELSE 'Y' END) AS "GSTFlag"

FROM (SELECT DCFullRate.DataCollectionID, DCFullRate.ServiceTypeID, DCFullRate.CustomerID,
 (DCFullRate.Cost + (CASE WHEN '+sGByte+' > DCFullRate.Usage THEN
 (DCFullRate.PartCost * ('+sGByte+' - DCFullRate.Usage)) ELSE 0 END)) AS "Cost"

FROM (SELECT DCRate.*, (CASE WHEN tRate.Length IS NULL THEN 0 ELSE tRate.Length END) AS "Usage",
 (CASE WHEN tRate.PartCost IS NULL THEN 0 ELSE tRate.PartCost END) AS "PartCost"
FROM (SELECT DC0.*, Min(tRate.Cost) AS "Cost"
FROM (SELECT tDataCollection.ID AS "DataCollectionID",
 tServiceID.ServiceTypeID, tGroup.CustomerID
FROM tDataCollection
LEFT JOIN tServiceID ON tDataCollection.ServiceID = tServiceID.ServiceID
LEFT JOIN tCentre ON tServiceID.CustomerCentreID = tCentre.ID
LEFT JOIN tDepartment ON tCentre.DepartmentID = tDepartment.ID
LEFT JOIN tGroup ON tDepartment.GroupID = tGroup.ID
WHERE tDataCollection.BatchID = 24039
AND tDataCollection.RevenueFlag = 0) AS DC0
LEFT JOIN tRate ON ((DC0.ServiceTypeID = tRate.ServiceTypeID)
 AND (0.15 >= tRate.Length) AND (tRate.Active = 1))
GROUP BY DC0.DataCollectionID, DC0.ServiceTypeID, DC0.CustomerID) AS DCRate
LEFT JOIN tRate ON ((DCRate.ServiceTypeID = tRate.ServiceTypeID)
 AND (tRate.Cost = DCRate.Cost) AND (tRate.Active = 1))
WHERE tRate.Cost = DCRate.Cost) AS DCFullRate) AS DC1

LEFT JOIN tDataCollection ON DC1.DataCollectionID = tDataCollection.ID) AS DC2) AS DC3
LEFT JOIN tDataCollection ON DC3.DataCollectionID = tDataCollection.ID