USP_GLOBALCHANGE_GETINFORMATIONBYID

            CREATE procedure dbo.USP_GLOBALCHANGE_GETINFORMATIONBYID
            (
                @ID as uniqueidentifier
            )
            as
                select
                    GLOBALCHANGE.ID as GLOBALCHANGEID,
                    GLOBALCHANGE.NAME as GLOBALCHANGENAME,
                    coalesce(GLOBALCHANGECATALOG.PROCEDURENAME,'') as GLOBALCHANGEPROCEDURENAME,
                    coalesce(GLOBALCHANGE.GLOBALCHANGEDATAFORMITEM,'') AS GLOBALCHANGEDATAFORMITEM,
                    GLOBALCHANGECATALOG.ID as GLOBALCHANGECATALOGID,
                    GLOBALCHANGECATALOG.FORMMETADATAXML as GLOBALCHANGECATALOGFORMMETADATA,
                    GLOBALCHANGE.LASTRUNON,
                    GLOBALCHANGECATALOG.GLOBALCHANGESPECXML as GLOBALCHANGESPECXML,
                    case when exists
                    (
                        select 
                            1 
                        from 
                            INFORMATION_SCHEMA.PARAMETERS 
                        where 
                            SPECIFIC_SCHEMA = 'dbo' 
                            and SPECIFIC_NAME = GLOBALCHANGECATALOG.PROCEDURENAME
                            and PARAMETER_NAME = '@CURRENTAPPUSERID'
                            and DATA_TYPE = 'uniqueidentifier'
                    )
                        then cast(1 as bit)
                        else cast(0 as bit) 
                    end as ISCURRENTAPPUSERPARAMETERDEFINED
                from
                    dbo.GLOBALCHANGE
                    inner join dbo.GLOBALCHANGECATALOG on GLOBALCHANGECATALOG.ID = GLOBALCHANGE.GLOBALCHANGECATALOGID                    
                where
                    GLOBALCHANGE.ID = @ID;