-- =============================================
-- Author:		Jas Rademeyer
-- Create date: 2018/01/06
-- Description:	Returns qt_Customers table for specified trading name
-- =============================================
ALTER PROCEDURE [dbo].[sp_GetCustomerFromTradingName]
	-- Add the parameters for the stored procedure here
	@tradingName VARCHAR(MAX)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT	C.*
	FROM	dbo.qt_Customers C
	WHERE	C.CustomerDetails_CustomerDetails_CustomerTradingName = @tradingName

END
