We are using a stored procedure to fetch data after a user enter filters/criteria.
If three different criteria under different classification are selected,then three temporary tables are created to store this condition initially.
Then the temporary tables values are used with original query to get matching records.
Will there will be issue of overlapping the data when multiple users are accessing
the same stored procedure or will it cause any lock situation?