IF EXISTS(SELECT 1 FROM sys.views WHERE Name = 'quotes_vQuoteGridItems')
DROP VIEW [dbo].[quotes_vQuoteGridItems]
GO

CREATE VIEW [dbo].[quotes_vQuoteGridItems]
AS
SELECT	[recId]
		,[itemID]
		,[QuoteInformation_QuoteNumber]
		,[None_QuoteInformation_QuoteDate]
		,[QuoteInformation_CustomerTradingName]
		,[None_QuoteInformation_ContactName]
		,[CreatedByDisplay]
		,[StatusDisplay]
		,[QuoteItems_QuoteItems_QuoteItemsNotes]
FROM	dbo.quotes_vQuotes
GO