USP_DATALIST_DESIGNATIONSGETNOTE

Gets the notes associated with a designation and a note type.

Parameters

Parameter	Parameter Type	Mode	Description
@NOTETYPEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@DESIGNATIONID	uniqueidentifier	IN	Designation ID

Definition

Copy



          CREATE procedure dbo.USP_DATALIST_DESIGNATIONSGETNOTE(@NOTETYPEID uniqueidentifier, @DESIGNATIONID uniqueidentifier)
          as
              set nocount on;

              declare @LEVEL1 uniqueidentifier,@LEVEL2 uniqueidentifier,@LEVEL3 uniqueidentifier,@LEVEL4 uniqueidentifier,@LEVEL5 uniqueidentifier

           select
            @LEVEL1 = [DESIGNATION].[DESIGNATIONLEVEL1ID],
            @LEVEL2 = [DESIGNATION].[DESIGNATIONLEVEL2ID],
            @LEVEL3 = [DESIGNATION].[DESIGNATIONLEVEL3ID],
            @LEVEL4 = [DESIGNATION].[DESIGNATIONLEVEL4ID],
            @LEVEL5 = [DESIGNATION].[DESIGNATIONLEVEL5ID]
            from dbo.[DESIGNATION]
           where [DESIGNATION].ID = @DESIGNATIONID

            declare @DESIGNATIONLEVEL uniqueidentifier

            if (@LEVEL5 is not null)
             set @DESIGNATIONLEVEL = @LEVEL5
            else
             if (@LEVEL4 is not null)
              set @DESIGNATIONLEVEL = @LEVEL4
              else
                if(@LEVEL3 is not null)
                 set @DESIGNATIONLEVEL = @LEVEL3
                 else
                  if (@LEVEL2 is not null)
                   set @DESIGNATIONLEVEL = @LEVEL2
                   else
                    if (@LEVEL1 is not null)
                     set @DESIGNATIONLEVEL = @LEVEL1

          if @DESIGNATIONLEVEL is not null
             select distinct dln.HTMLNOTE, dln.TEXTNOTE from DESIGNATIONLEVELNOTE dln
               where dln.DESIGNATIONLEVELID = @DESIGNATIONLEVEL and dln.DESIGNATIONLEVELNOTETYPECODEID = @NOTETYPEID