Thanks to all for replying this post. Lowell's post was really helpful. I was looking for this kind of solution. Thanks

Thanks ah.nasr

Its working,

I am sorry I didn't under stand previously.

There are two type of items one is Serialized like IMEI, SIM etc. and non serialized items like battery, charger etc.. Serialized item always going to be one in one...

Hi Andrew,

Actually this is a client requirement. Client needs a facility to update status of the Item i.e. Faulty, Lost, Sold etc. for each item. So in case of one...

Yes exactly same row for three times

I want to take output as a table and want to use it in other stored procedure.