Multiple Column Result From One Table

Hi,
I have a table like this :

TimeIDApplicationLoginState
1App1login10
1App2login21
1App3login31
1App1login40
1App1login51
1App4login10
2App1login10
2App2login20
2App3login31
2App1login40
2App1login51
2App4login10
3App1login10
3App2login21
3App3login31
3App1login40
3App1login51
3App4login10

And I want a result like this
TimeID (state=0) (state=1)
1 3 3
2 4 2
3 3 3

I use this code :

set nocount on
declare @timeid1 int
declare @timeid2 int
declare @timeid int
declare @sessionstate int
declare @count1 int
declare @count2 int
declare @count int
declare @aux int

declare txt_cursor cursor for

select timeid, sessionstate , count(login) from metromaster
where sessionstate = 0
group by timeid, sessionstate
UNION
select timeid, sessionstate , count(login) from metromaster
where sessionstate = 1
group by timeid, sessionstate
order by timeid

open txt_cursor
select @aux = 0
fetch next from txt_cursor into @timeid, @sessionstate, @count
while (@@fetch_status = 0)
begin
if @aux = 0
begin
select @timeid1 = @timeid
select @count1 = @count
select @aux =1
end
else
begin
select @timeid2 = @timeid
select @count2 = @count
select @aux = 2
end
if @aux = 2
begin
--select @timeid1, @count1, @sessionstate, @count2, @timeid2
select @timeid1, @count1, @count2
select @aux = 0
end
fetch next from txt_cursor into@timeid, @sessionstate, @count

end
close txt_cursor
deallocate txt_cursor
set nocount off

But it create a lot of blank row and field header.
Does anyone know an other methode ??

Thanks.