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