something likeINSERT INTO Databases (Servername,databases,FKAutoID)SELECT d.Servername,f.val,s.AutoIDFROM databases dCROSS APPLY dbo.ParseValues(d.databases,' ')fINNER JOIN Servers sOn s.Servername = d.ServernameWHERE f.ID > 1UPDATE dSET d.Databases = f.Val,d.FKAutoID = s.AutoIDFROM databases dCROSS APPLY dbo.ParseValues(d.databases,' ')fINNER JOIN Servers sOn s.Servername = d.ServernameWHERE f.ID = 1
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs