-- اضافه کردن همه دسترسی های یک نقش به نقش دیگر با تگ

-- مبدا
DECLARE @FromTag nvarchar(100) = '201',

-- مقصد 
		
@ToTag nvarchar(100) = '200'

delete SamanRole_Roles WHERE saman_role_id IN (SELECT TOP 1 id FROM SamanRoles WHERE deleted = 0 AND tag = @ToTag)
insert INTO SamanRole_Roles
SELECT (SELECT TOP 1 id FROM SamanRoles WHERE deleted = 0 AND tag = @ToTag),role_id FROM SamanRole_Roles WHERE saman_role_id IN (SELECT TOP 1 id FROM SamanRoles WHERE deleted = 0 AND tag = @FromTag)