// Form of the test for incomplete service splits.
// Used in SaveToTransaction().
SELECT DC1.*
FROM (SELECT DC.SID, DC.ServiceID, Sum(RentPercentage) AS "Rent", Sum(CallPercentage) AS "Call", Sum(OtherPercentage) AS "Other"
FROM ((SELECT DISTINCT tDataCollection.ServiceID, tServiceID.ID AS SID,
 (CASE WHEN tDataCollection.ServiceType IS NULL THEN tServiceType.Code ELSE tDataCollection.ServiceType END) AS "Code"
 FROM (tDataCollection
 LEFT JOIN tServiceID ON tDataCollection.ServiceID = tServiceID.ServiceID)
 LEFT JOIN tServiceType ON tServiceID.ServiceTypeID = tServiceType.ID
 WHERE tDataCollection.BatchID = 11111
 AND tDataCollection.RevenueFlag IS NULL
 AND tServiceID.ServiceID IS NOT NULL) AS DC
LEFT JOIN tServiceType ON DC.Code = tServiceType.Code)
INNER JOIN tServiceSplit ON DC.SID = tServiceSplit.ServiceID
WHERE tServiceType.SplitService = 1
AND tServiceSplit.ServiceID IS NOT NULL
AND tServiceSplit.Active = 1
GROUP BY DC.SID, DC.ServiceID) AS DC1
WHERE DC1.Rent <> 100
AND DC1.Call <> 100
AND DC1.Other <> 100