fnTransactions_GetUnprocessedTransForMembership
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientID | int | IN |
Definition
Copy
CREATE function [dbo].[fnTransactions_GetUnprocessedTransForMembership](@ClientID int)
returns table as
return (
select top 100 percent mt.ID,mt.DateAdded,mt.AddedByUserID,mt.XMLObjectData
from dbo.MembershipTransactions mt inner join ClientMemberships cm on cm.id=mt.ClientMembershipsID
inner join SiteContent sc on sc.id=cm.SiteContentID
where sc.ClientSitesID= @ClientID
and mt.processed_date is null
and mt.Status = 1
order by mt.ID )