Is this possible? I know its not very efficient but its something I would like to try out.
Say for example I want to link TableA.Name to TableB.Name and the declared variable is @pay.. would I need something like:
select @pay = Name from inserted inner join TableA.Name on TableB.Name = Name
Say for example I want to link TableA.Name to TableB.Name and the declared variable is @pay.. would I need something like:
select @pay = Name from inserted inner join TableA.Name on TableB.Name = Name