I work on sql server 2017 I have issue How to allow mutli user working on same table without using temp table and without interact two user with same data as example
user a :
exec sp_workingmultiuser 5
user b :
exec sp_workingmultiuser 10
create proc sp_workingmultiuser @productid int as begin
select * into dbo.testtrade from parts.tradecodes where productid=@productid
end
so my question if user a using product id 5 and user b using product id 10 on same time
data for user b will display for user a
so how to prevent that please ?