DaniWeb IT Discussion Community - View Single Post

Re: Trouble Ticket System

Oct 15th, 2008

Thanks for your help.

I've actually used the solution given to me in another forum and it seems to work:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT	TicketID,
	Date,
	Category,
	STATUS
FROM	(
		SELECT	TicketID,
			Date,
			Category,
			STATUS,
			ROW_NUMBER() OVER (PARTITION BY TicketID ORDER BY Date DESC) AS RecID
		FROM	Tickets
	) AS d
WHERE	RecID = 1
SELECT	TicketID,
	Date,
	Category,
	Status
FROM	(
		SELECT	TicketID,
			Date,
			Category,
			Status,
			ROW_NUMBER() OVER (PARTITION BY TicketID ORDER BY Date DESC) AS RecID
		FROM	Tickets
	) AS d
WHERE	RecID = 1