USP_DATAFORMTEMPLATE_VIEW_FAFDONATIONBUSINESSPROCESSDETAIL

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FAFDONATIONBUSINESSPROCESSDETAIL
(
    @DATALOADED bit = 0 output,
    @LASTUPDATEDVALUE nvarchar(20) = null output
)
as
    set nocount on;
declare @ID uniqueidentifier
set @ID='012D2720-6840-444E-B316-FB2C1EF8019B'

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.
  SET @DATALOADED=1

select 
  @DATALOADED=1,
  @LASTUPDATEDVALUE=(
    CASE 
        WHEN isNULL(S.LASTRUNTIME, '') = '' THEN 'Never'
        WHEN DATEDIFF(MI, S.LASTRUNTIME, GETDATE()) = 1 THEN CONVERT(varchar(5), DATEDIFF(MI, S.LASTRUNTIME, GETDATE())) + ' minute ago'
        WHEN DATEDIFF(MI, S.LASTRUNTIME, GETDATE()) < 60 THEN CONVERT(varchar(5), DATEDIFF(MI, S.LASTRUNTIME, GETDATE())) + ' minutes ago'
        WHEN DATEDIFF(HH, S.LASTRUNTIME, GETDATE()) = 1 THEN CONVERT(varchar(5), DATEDIFF(HH, S.LASTRUNTIME, GETDATE())) + ' hour ago'
        WHEN DATEDIFF(HH, S.LASTRUNTIME, GETDATE()) < 24 THEN CONVERT(varchar(5), DATEDIFF(HH, S.LASTRUNTIME, GETDATE())) + ' hours ago'
        WHEN DATEDIFF(D, S.LASTRUNTIME, GETDATE()) = 1 THEN CONVERT(varchar(5), DATEDIFF(D, S.LASTRUNTIME, GETDATE())) + ' day ago'
        ELSE CONVERT(varchar(5), DATEDIFF(D, S.LASTRUNTIME, GETDATE())) + ' days ago' END)
from BUSINESSPROCESSSCHEDULE BPS
inner join SCHEDULE S
    on BPS.SCHEDULEID=S.ID
where BPS.BUSINESSPROCESSID=@ID

    return 0;