You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
12 lines
325 B
12 lines
325 B
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) |