SELECT tRate.*
FROM tRate
WHERE (tRate.ServiceType = )
AND (tRate.Length = 0)
AND (tRate.Active = 1)


INSERT INTO tDataCollection
(ServiceID, DateFrom, DateTo, TransactionType, AmountExGST, GSTAmount, AmountIncGST, GSTFlag)
 SELECT tServiceID.ServiceID, , , , 0, 0, 0, 'Y'
 FROM tServiceID
 WHERE ServiceTypeID = 
 AND Active = 1



SELECT ParmText
FROM tParameter
WHERE tParameter.Parm LIKE 'CAMSBaseDataServiceID'






SELECT CAST(CAST(DC1.Cost AS real) AS varchar) AS "RateCost",
 CAST(ServiceTypeID AS varchar) AS "ServiceType"
FROM (

SELECT Max(tRate.Cost) AS "Cost", DC0.ServiceTypeID
FROM (

SELECT DISTINCT tServiceID.ServiceTypeID
FROM tDataCollection
LEFT JOIN tServiceID ON tDataCollection.ServiceID = tServiceID.ServiceID
WHERE tDataCollection.BatchID = '+ sBatchID
AND tDataCollection.RevenueFlag = 0

) AS DC0
LEFT JOIN tRate ON ((DC0.ServiceTypeID = tRate.ServiceTypeID)
 AND (tRate.Active = 1)
 AND ('+ sGByte+ ' >= tRate.Length))
GROUP BY DC0.ServiceTypeID

) AS DC1
WHERE DC1.Cost <> 0