IF EXISTS(SELECT name FROM sysobjects
          WHERE name = 'FILISERVFILI')
   DROP VIEW FILISERVFILI
GO

CREATE VIEW FILISERVFILI AS (
   SELECT 
          SRV.CDFILIAL+SRV.CDSERVFILI AS CDFILISERVFILI,
          SRV.NMSERVICO
   FROM  
          SERVICO SRV, FILIAL FI
   WHERE 
          SRV.CDFILIAL = FI.CDFILIAL
)
GO

-- VERSAO --
EXEC ATUVEROBJ 'FILISERVFILI','4.11.184';
GO
