;WITH
			cteGetNewVSOldGroup (oldGroupId, newGroupId)
			AS
			(
				select t1.oldGroupId,t2.id from #tblGroups t1 Inner join 
				[DB1].[dbo].Dyn_Group t2 on t1.name=t2.name
				where t2.CompanyRef=@newCompanyRef and t2.UserRef=@newUserId
			)
		INSERT INTO [DB1].[dbo].[Dyn_Group2]
           ([GrandParent]
           ,[Parent]
           ,[Child])
		select t2.newGroupId,t3.newGroupId,t4.newGroupId from #tblGroup2Group t1
		inner join cteGetNewVSOldGroup as t2 on t1.GrandParent=t2.oldGroupId
		inner join cteGetNewVSOldGroup as t3 on t1.Parent=t3.oldGroupId
		inner join cteGetNewVSOldGroup as t4 on t1.Child=t4.oldGroupId

INSERT INTO dbo.Con_User2Group(EndUserRef,GroupRef)
	SELECT  t3.id,t4.newGroupId
	FROM   .dbo.Con_User2Group t1 INNER JOIN
           Users t2 ON t1.EndUserRef = t2.ID INNER JOIN
		   dbo.Users2 t3 on t2.PhoneNumber=t3.PhoneNumber COLLATE SQL_Latin1_General_CP1_CI_AS
			INNER JOIN cteGetNewVSOldGroup t4 on t4.oldGroupId=t1.GroupRef
	WHERE  (t2.CompanyRef = @oldCompanyRef) and t2.UserRef=@oldUserId
		and (t3.CompanyRef = @newCompanyRef) and t3.UserRef=@newUserId

quote:

---

Originally posted by pelegk2

you mean that afer the first time i use it it "expires"?

---