USP_CODETABLEDESCRIPTION_FROM_ID

Returns a codetable description from a table name and an ID.

Parameters

Parameter	Parameter Type	Mode
@CODETABLENAME	nvarchar(100)	IN
@CODETABLEVALUEID	uniqueidentifier	IN
@RETVAL	nvarchar(100)	INOUT

Definition

Copy



            CREATE procedure dbo.USP_CODETABLEDESCRIPTION_FROM_ID(@CODETABLENAME nvarchar(100), 
          @CODETABLEVALUEID uniqueidentifier, 
          @RETVAL nvarchar(100) output)

          as
          begin
              declare @sql nvarchar(max);

              if len(@CODETABLENAME) > 0
                  begin
                      set @sql = 'select @RETVAL = DESCRIPTION from dbo.' + @CODETABLENAME + ' where ID = @ID';
                      set @RETVAL = '';

                      exec sp_executesql @sql, N'@RETVAL nvarchar(100) output, @ID uniqueidentifier',
                          @RETVAL = @RETVAL output, @ID = @CODETABLEVALUEID
                  end
          end