what is this query when written as a stored procedure?

[jgoodman00]

I have the following query in access:
UPDATE ADOPT INNER JOIN tblBrsCodes ON (ADOPT.brsno = tblBrsCodes.BrsCode) AND (ADOPT.road = tblBrsCodes.Road) SET ADOPT.BrsID = tblBrsCodes!BrsID;

We are in the process of switching to a SQL Server databasem, with an Access project front-end.

Any ideas how I can achieve this? James Goodman
j.goodman00@btinternet.com

 

[geramis]

you can try this:

UPDATE ADOPT A
SET A.BrsID = (SELECT BrsID
FROM tblBrsCodes B
WHERE B.BrsCode = A.brsno
AND B.Road = A.road )