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 ?