Thanks Phil for your great and quick response. It is definately works out but because of we have inconsistent data it was giving an error like

Invalid Length Passed for...

Fantastic Dilip and Sushila. Both of your queries works great for me.

infact Thanks dilip for responding so quickly. It solves my problem so far.

thanks so much

Feeling better

Harshen

Well That's a Great Response and It really Works. However in My Table i have couple of more columns like title,Abstract associated with Every Row.

Just Image in My TempTable it...

Well I have tried with distinct but it won't give me the output as i wanted.It will select distinct ARticleid but since MediaAsset is also associated with it, It will...