UFN_SURVEYDOWNLOADPROCESS_GETCURRENTENDPOINT

Returns the last end point returned from the survey response download process.

Return

Return Type
datetime

Definition

Copy



            create function dbo.UFN_SURVEYDOWNLOADPROCESS_GETCURRENTENDPOINT()
            returns datetime
            as 
            begin
                declare @CURRENTENDPOINT datetime

                set @CURRENTENDPOINT = coalesce((select 
                     CURRENTENDPOINT
                from 
                    dbo.SURVEYDOWNLOADPROCESS
                where
                    ID = 'CE06A9F5-8A55-4294-B041-90A58AC83F73'), '1/1/1753')

                return @CURRENTENDPOINT
            end