That i am not sure.. coz the developers need help & so they asked us whether we can provide the solution to them..

They have optimized the query .. still deadlock comes..

When i see the Stored procedure i saw that Select form Table 1 & next query is Update to Table 1....

& many users are using & executing the same sp for fetching the report & many users are updating the records..