• I do not know how to post real table but I did the same case using .net in application (create a dataset and then looping in dataset).

    Now, I want to use store procedure to do it but I do not know how to do in SQL.