Hi,

very good post..

But when deadlock occured i recived attachment in text file but sadly it didn't contain any data.

Is there something in select query? coz i cross check data inserted in a table propely but slect query didn't get any data degarding deadlock