SQLServer2005 procedures

[rahulae]

given a valid agent,system should report number of properties assigned to it.

Property table:(property _id,property_na me,asking_price ,agent_id,total _size,status,ad dress,city,stat e)

[Delerna]

Is this homework?
Its looking an awful lot like homework. This and the other one you asked here are pretty basic queries.