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