All the data comes from the same table. It needs to read from the table called dsdba.itemgroups to find all records with the same parentguid and it is into this...

DO you think it is possible to do without calling a new stored procedure because it needs to execute everything thats done in the existing stored procedure but i'm conscious...

The stored procedure im using is below, i'm unclear as to where i would put the while statement into here, also is there no way i can do the while...

thats great, thankyou

I have tried the code like you suggested where i changed the fetch command to:

FETCH NEXT FROM TABLECURSOR INTO @PART,@DIGIT

.....

.....

BEGIN

PRINT @PART

PRINT @DIGIT

FETCH NEXT FROM TABLECURSOR INTO @PART,@DIGIT

but i get...