Urgent Help! - How To Get The Column Selection?

suppose i have a table penalties with
ticket_number, ticket_start_date datetime, ticket_end_date datetime

There are many records of same ticket_number.example:
ticket_number ticket_start_date ticket_end_date
75 2/1/03 3/2/03
75 2/4/03 5/4/03

34 2/1/03 3/3/04
34 3/4/04 3/3/05


I want to write a query which will:
1. select the ticket_number which is not active as of today
in case of ticket_number 75 it is closed so I want to print it in report

in case of 34 it was closed but now opened, so i don't want in my report.

Could anybody suggest a query how to do it?

I was trying with stored procedure and cursor :


-------------------------------------
CREATE PROCEDURE simpleTest

AS

declare @Today datetime
set @Today = '10/04/2004'
declare @colA varchar(38)
declare @colB datetime
declare @colC datetime
declare @myCursor CURSOR

set @myCursor = CURSOR FAST_FORWARD
for
select distinct ticket_number, ticket_start_date, ticket_end_date
from penalties
where ticket_end_date <= @Today

open @myCursor
fetch next from @myCursor
into @colA, @colB, @colC

while @@fetch_status=0
begin
print @colA
print @colB
print @colC
fetch next from @myCursor
into @colA, @colB, @colC
end

close @myCursor
deallocate @myCursor



GO

-- =============================================
-- example to execute the store procedure
-- =============================================
EXECUTE simpleTest
GO
-------------

however this gives closed tickets but multiple records. I want only the last record details of the ticket_number.
I tried last(ticket_number) in my query, but it doesn't affect.
Please suggest! thanks.
I am using MS SQL server.