I'm still not clear on exactly what you're trying to do But I am curious, is this going to be a stored procedure solution or do you have the flexibility to do a laguage solution VB6 (for example). The reason I ask is because it appears that what you are trying to do would be more suited to a recordset loop in VB than cursors

[Edited by JHausmann on 06-05-2000 at 01:44 PM]