Hi All, I have a table and fields like below and data should be insert like the format below APPSER DOCID 1 1 2 1 3 2 1 2 2 3 3 1 i want to write a insert stored procedure so that user just enter the DOCID and APPSER should come in the above format automatically by stored procedure..i need your help my friends please. Thanks & Good Day