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", tDataCollection.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 = '+sVRTID+' THEN 'N' ELSE 'Y' END) AS "GSTFlag"
FROM (SELECT DC0.*, Max(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 = 11111
AND tDataCollection.RevenueFlag = 0) AS DC0
LEFT JOIN tRate ON ((DC0.ServiceTypeID = tRate.ServiceTypeID) AND (0.2222 >= tRate.Length))
GROUP BY DC0.DataCollectionID, DC0.ServiceTypeID, DC0.CustomerID) AS DC1
LEFT JOIN tDataCollection ON DC1.DataCollectionID = tDataCollection.ID) AS DC2) AS DC3
LEFT JOIN tDataCollection ON DC3.DataCollectionID = tDataCollection.ID