USP_RE7GETATTRIBUTES

create procedure [dbo].[USP_RE7GETATTRIBUTES]
(
  @RECORDTYPE int
)
as
  set nocount on;
  if @RECORDTYPE is not null
  begin
    select [LOCALID],[NAME],[TYPEOFDATA],[CODETABLE_LOCALID] from [RE7].[ATTRIBUTETYPECODE] where [RECORDTYPE] = @RECORDTYPE;
  end