How to allow multi user work on same table without any issue of intera

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 ?