/****** Object:  StoredProcedure [rdld].[GetOrderNumbersRow]    ******/
-- =============================================
-- Author:     Jeff Spindler
-- Date: 8/22/2022 - HB2J+2
-- Description:   Gets the table
-- =============================================
CREATE PROCEDURE [rdld].[GetOrderNumbersRow]
   @PriKey   INT
AS
BEGIN
   SET NOCOUNT ON;
   SET DEADLOCK_PRIORITY LOW;

   SELECT TOP(1)
      [Description]
      ,[Prefix]
      ,[Minimum]
      ,[Maximum]
      ,[YearLength]
      ,[NextYear]
      ,[CurrentYear]
      ,[NextNoInSeq]
      ,[NextYrNextNo]
      ,[VanlineFID]
      FROM OrderNumbers onums
      Where OrderNumbersID = @PriKey
      for xml raw;
END
GO
GRANT EXECUTE ON  [rdld].[GetOrderNumbersRow] TO [MssExec]
GO