/****** Object:  StoredProcedure [rdld].[GetShippingDetails]    Script Date: 8/28/2020 10:18:55 AM ******/
-- =============================================
-- Author:     Jeff Spindler
-- Date: 2/2022
-- Description:   Gets the table
-- =============================================
CREATE PROCEDURE [rdld].[GetShippingDetails]
   @OrdPriKey   INT,
   @outXml varchar(max) output
AS
    BEGIN
        SET NOCOUNT ON;
        set @outXml =
      (
        SELECT [Description],
               [Length],
               [Width],
               [Height],
               [SequenceNumber]
        FROM SCShippingDetails
        Where SCShippingDetails.OrdPriKey =  @OrdPriKey
        order by SCShippingDetails.OrdPriKey
        FOR XML RAW
        );
        RETURN 0;
    END;
GO
GRANT EXECUTE ON  [rdld].[GetShippingDetails] TO [MssExec]
GO