Get Timephased data

[Microsoft Communities]

Hi,

I read how to get timephased data on MSDN:
http://msdn.microsoft.com/en-us/library/aa208968(office.11).aspx
I use the sp_psactualsbyday.sql Script to extract data day by day, but the
result is not right with MS Project schedule which I published (MSP 2003
Pro)

MSP 2003:
Name: Test20080121
WBS Program ID Task Name Start
Finish Deadline Work Duration Resource
1.1.1 Program ID 1 Basic Design 2007/08/01 2007/08/01NA8 h 1 d Dinh Bao Tuyen
1.1.2 Program ID 1 Review Basic Design 2007/08/01 2007/08/02 NA 16 h2d Dinh Bao Tuyen
1.1.3 Program ID 1 Detail Design 2007/08/01 2007/08/03NA24 h 3 d Dinh Bao Tuyen
1.1.4 Program ID 1 Review Detail Design 2007/08/01 2007/08/06 NA 32
h 4 d Dinh Bao Tuyen
1.1.5 Program ID 1 Coding 2007/08/01
2007/08/07 NA 40 h 5 d Dinh Bao Tuyen
1.1.6 Program ID 1 Review Code 2007/08/01 2007/08/08 NA48h 6 d Dinh Bao Tuyen
1.1.7 Program ID 1 Testing 1 2007/08/012007/08/09 NA56 h 7 d Dinh Bao Tuyen

All task have 0h (actual work )

select substring(r.res_name,0,15) as Resource,
substring(p.proj_name,0,15) as Project,
td.AssignmentTimeStart,
td.AssignmentTimeFinish,
(td.AssignmentTimeActualWork / 1000) / 60 as Hours
from msp_web_projects p,
msp_web_assignments a,
msp_web_resources r,
msp_view_proj_assn_tp_by_day td
where p.wproj_id = a.wproj_id
and a.wres_id = r.wres_id
and a.assn_uid = td.AssignmentUniqueID
and AssignmentTimeActualWork is not null

Result:
Dinh Bao Tuyen Test20080121 2008-06-09 00:00:00.000 2008-06-10
00:00:00.000 0.75000000000000
Dinh Bao Tuyen Test20080121 2008-06-10 00:00:00.000 2008-06-11
00:00:00.000 0.75000000000000
Dinh Bao Tuyen Test20080121 2008-03-25 00:00:00.000 2008-03-26
00:00:00.000 0.99666666666666
Dinh Bao Tuyen Test20080121 2008-12-13 00:00:00.000 2008-12-14
00:00:00.000 0.50000000000000
Dinh Bao Tuyen Test20080121 2008-09-29 00:00:00.000 2008-09-30
00:00:00.000 0.00000000000000
Dinh Bao Tuyen Test20080121 2008-09-30 00:00:00.000 2008-10-01
00:00:00.000 0.00000000000000

In schedule, there is no task start in 2008, but the result have.

How to resolve it?

Thanks