USP_DESIGNATION_SETNAME

create procedure dbo.USP_DESIGNATION_SETNAME
(
    @DESIGNATIONIDS UDT_GENERICID readonly
)
as
begin
    update D set
        NAME = N.NAME
    from
        @DESIGNATIONIDS I
        inner join dbo.DESIGNATION D on I.ID = D.ID
        inner join dbo.UFN_DESIGNATION_BUILDNAME_BULK() N on N.ID = D.ID
end