My First Cursor Programming

Declare @pptid int,
@credate  date

declare ppt cursor for
select PD.PropertyID ,PD.CREATIONDATE   from PropertyDetails PD with(nolock)
inner join OfficeInformation OI with(nolock)
 on PD.ListingOfficeID = OI.OfficeID
inner join AgencyInformation AI with(nolock)
 on OI.AgencyID = AI.AGENCYID where AI.GroupID=116

open ppt

fetch ppt into @pptid, @credate

while @@FETCH_STATUS =0
begin
exec ProxioCentralLog.PC.RecChangePropertyDetails @pptid,@credate
end
close ppt

deallocate ppt


links::
http://www.java2s.com/Code/SQLServer/Cursor/CatalogCursor.htm