Code: Select all
CREATE PROCEDURE [dbo].[SPR_UpdateRegisterNameFromActivity](@NumRecords int OUTPUT)
AS
BEGIN
SET NOCOUNT ON;
UPDATE R
SET R.r_name = A.a_name
FROM ulive.dbo.capd_register R
INNER JOIN ulive.dbo.capd_activity A
ON A.a_register = R.r_id
WHERE
R.r_name IS NULL
AND A.a_name IS NOT NULL
SET @NumRecords = @@ROWCOUNT
END