fnGetNextImportToProcess
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @uDate | datetime | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnGetNextImportToProcess] (@uDate datetime)
RETURNS int AS
BEGIN
--pass in current utcdate in @udate
--Queued and not deferred or deferred and procession date has lapsed
DECLARE @ID int
SELECT TOP 1 @ID = [ID]
from userimport where
(Status=1) and ((Deferprocess=0) OR ((deferprocess=1) and (isnull(ProcessOn, @uDate)<=@uDate)))
IF @@ROWCOUNT = 0
SELECT @ID = 0
RETURN @ID
END