/****** Object:  StoredProcedure [rdld].[[GetTradeShows]] ******/
-- =============================================
-- Author:     Jeff Spindler
-- Date: 2/8/22
-- Description:   Gets the Trade Show xml for inclusion in uploaded order
-- =============================================
   CREATE PROCEDURE [rdld].[GetTradeShows]
   @OrdPriKey   INT,
   @outXml varchar(max) output
   AS
   BEGIN
      set nocount on
      set @outXml =
      (
         select
            TradeShow.ShowCode
            , TradeShow.TradeShowName
            , TradeShow.BoothNumber
            , TradeShow.OriginDestinationFlag
         from TradeShow
         where TradeShow.OrdersFID = @OrdPriKey
         for xml raw
      );
   END;
GO
GRANT EXECUTE ON  [rdld].[GetTradeShows] TO [MssExec]
GO