fnTransactions_GetUnprocessedProfiles
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientID | int | IN |
Definition
Copy
CREATE function dbo.fnTransactions_GetUnprocessedProfiles(@ClientID int)
returns table as
return (
select top 100 percent ProfileUpdateTransactionsID,DateLastChanged ,XMLObjectData, BackOfficeID, AddedByUserID
from dbo.ProfileUpdateTransactions
where clientsID = @ClientID
and processed_date is null AND isDeleted = 0 and Not BackOfficeID is null
order by ProfileUpdateTransactionsID
)