Nothing is contradicting Bhuvnesh.

I just want to store the results in a table and for that i thought stored procedure would work best .

I want the proc to read each row and then insert it in table .. whats seems contradicting in it ....??? :O

My current procedure only reads the first row from the resultset of this query.

Hope u understand the case now.