i created stored procedure fro migrating the data from one sqlserver databse another sqlserver database.

My task is ther is workflow of xxxxxx.

i have to display sequence no increments based on the no of times the borrower completed the task(activity).

i have different task no's like 1,2,3,4

Here 1 and 2 tasks should do one time,the 3 and 4 can repeat multiple times.

this is the req.

i written the query in my post.

thanks,