I have written app using sql server as backend, it just a simple reporting,
i have created a X table to store data taken from various table and use the X table as source for reporting, if one user is accessing the x table to generate report its 100% Ok, but if by change another user generate a report using X table as well, user 1 extracted data is being included in user 2 extracted data.

How can i prevent other user to access the table until the fist user has completed his report.

i've tried adlockpessimistic and open static not working

tnx
cyrus