USE [Vertragsverwaltung_20160404]
GO
/****** Object:  View [dbo].[TXP_IN_Offen]    Script Date: 02.12.2016 09:08:53 ******/
DROP VIEW [dbo].[TXP_IN_Offen]
GO
/****** Object:  View [dbo].[TXP_IN_Offen]    Script Date: 02.12.2016 09:08:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[TXP_IN_Offen]
AS
SELECT        TOP (100) PERCENT TicketID, Statusdatum AS Status_Changedate, TGNummer
FROM            dbo.TXP_Ticketdata_IN
WHERE        (Status <> 'Geschlossen' AND Status <> 'Geschlossen "AutoClose"' AND Status <> 'Warten auf Schliessung' AND Status <> 'Solved')



GO