>if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TabelaPrecos_V]') and OBJECTPROPERTY(id, N'IsView') = 1) >drop view [dbo].[TabelaPrecos_V] >GO > >SET QUOTED_IDENTIFIER ON >GO >SET ANSI_NULLS ON >GO > >/****** Object: View dbo.TabelaPrecos_V Script Date: 10/05/2004 08:41:33 ******/ >CREATE VIEW dbo.TabelaPrecos_V >AS >SELECT TOP 100 PERCENT dbo.PRODUTOS.ProdNome, dbo.PROD_PRECOS.ProdPrecPreco, dbo.PROD_PRECOS.ProdID, dbo.PROD_PRECOS.TabelaID, > dbo.PROD_PRECOS.ProdPrecID, dbo.TAB_PRECOS.FilialID >FROM dbo.PRODUTOS INNER JOIN > dbo.PROD_PRECOS ON dbo.PRODUTOS.ProdID = dbo.PROD_PRECOS.ProdID INNER JOIN > dbo.TAB_PRECOS ON dbo.PROD_PRECOS.TabelaID = dbo.TAB_PRECOS.TabelaID >WHERE (dbo.TAB_PRECOS.TabelaStatus = 0) AND (dbo.PRODUTOS.ProdStatus = 0) >ORDER BY dbo.PRODUTOS.ProdDesc > >GO >SET QUOTED_IDENTIFIER OFF >GO >SET ANSI_NULLS ON >GO > >