An object of TMSQuery contains this sql:
Code: Select all
select Payments.PayID, Payments.UserID, Payments.PayDate, Payments.PayTypeID, Payments.AddPayDate, PL.Attributes PLAttributes,
(SELECT dbo.Concatenate(S.PayServiceID) FROM PayedServices S (NOLOCK) WHERE S.FirmID=Payments.UserID AND S.PayID=Payments.PayID) AS PayedServicesStr,
PT.Attributes AS PTAttributes
FROM payments Payments (NOLOCK)
LEFT JOIN PayPlaces PL (NOLOCK) ON PL.PayPlaceID=Payments.PayPlaceID
LEFT JOIN InvoicePayTypes PT (NOLOCK) ON PT.PayTypeID=Payments.PayTypeID
WHERE Payments.UserID=100 AND ISNULL(Payments.Attributes,0)&2!=2
AND dbo.sf_IsNonPeriodServices(Payments.UserID, NULL, Payments.PayID)=0
ORDER BY Payments.PayDate, Payments.PayID