USP_BBNC_GETAPPEAL

            CREATE procedure dbo.USP_BBNC_GETAPPEAL
            (
                @BBNCID int
            )
            as
                set nocount on;

                select
                    [MAP].[ID] as [BBNCID],
          [MAP].[APPEALID],
                    [APPEAL].[NAME] as [SHORTDESCRIPTION],
                    [APPEAL].[DESCRIPTION] as [LONGDESCRIPTION],
                    [APPEAL].[ISACTIVE],
                    [APPEALCATEGORYCODE].[DESCRIPTION] as [CATEGORY],
                    [APPEAL].[STARTDATE],
                    [APPEAL].[ENDDATE],
                    [APPEAL].[GOAL],
                    [ADDEDBY].[USERNAME] as [ADDEDBY],
                    [CHANGEDBY].[USERNAME] as [CHANGEDBY],
                    [APPEAL].[DATEADDED],
                    [APPEAL].[DATECHANGED]
                from
                    dbo.BBNCAPPEALIDMAP as [MAP]
                    inner join dbo.APPEAL on [APPEAL].[ID] = [MAP].[APPEALID]
                    left join dbo.APPEALCATEGORYCODE on [APPEAL].[APPEALCATEGORYCODEID] = [APPEALCATEGORYCODE].[ID]
                    left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].[ID] = [APPEAL].[ADDEDBYID]
                    left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].[ID] = [APPEAL].[CHANGEDBYID]
                where
                    [MAP].[ID] = @BBNCID;