AU_Geschlossen (alt)


SELECT        TOP (100) PERCENT TicketID, MAX(Status_Changedate) AS Status_Changedate, TGNummer
FROM            dbo.TXP_Ticket_Data
WHERE        (Status_Neu = 'Geschlossen') AND (TicketID LIKE 'au_%')
GROUP BY TicketID, TGNummer
HAVING        (NOT (TGNummer IS NULL))
ORDER BY TicketID


(AU Offen Alt)