SQL Query producing some wrong data

[Felicity]

In SQL Query Analyzer, I'm running the following script to see what cancelled
tasks will delete from the project server database before I run the script to
actually delete the cancelled tasks:

select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME from
MSP_WEB_ASSIGNMENTS ma
join MSP_WEB_PROJECTS mp
ON ma.WPROJ_ID = mp.WPROJ_ID
join MSP_WEB_RESOURCES mr
ON ma.WRES_ID = mr.WRES_ID
where
ma.WASSN_DELETED_IN_PROJ <>0
order by 1

But it some instances, this script is also bringing up some completed tasks.
I don't want the completed tasks deleted. Does anyone know why this is
getting the completed tasks as well?

 

[Brian Kennemer]

In SQL Query Analyzer, I'm running the following script to see what
cancelled tasks will delete from the project server database before I
run the script to actually delete the cancelled tasks:

select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME from
MSP_WEB_ASSIGNMENTS ma
join MSP_WEB_PROJECTS mp
ON ma.WPROJ_ID = mp.WPROJ_ID
join MSP_WEB_RESOURCES mr
ON ma.WRES_ID = mr.WRES_ID
where
ma.WASSN_DELETED_IN_PROJ <>0
order by 1

But it some instances, this script is also bringing up some completed
tasks. I don't want the completed tasks deleted. Does anyone know
why this is getting the completed tasks as well?

Do the completed tasks have a non-zero value in the
WSSN_DELETED_IN_PROJ field?