Output

Before : PMKB_Testing.clsAddTagsAndLinks.RenameTag
TagID=0;TagName=codeplex;
TagID=0;TagName=links;
TagID=0;TagName=documents;
TagID=0;TagName=FAQ;
TagID=0;TagName=HELP;
UserID=0;UserName=andrei;
LinkID=0;LinkName=aa;LinkDescription=b;LinkUrl=a;CreationUserID=1;LinkCreationDate=1/8/2012 11:07:15 PM;LinkShortURL=;
INSERT INTO [Link_OLAP]
           ([LinkID]
           ,[LinkName]
           ,[LinkDescription]
           ,[LinkUrl]
           ,[CreationUserID]
           ,[LinkCreationDate]
           ,[LinkShortURL]
           ,[UserName]
           )
   select l.[LinkID]
           ,l.[LinkName]
           ,l.[LinkDescription]
           ,l.[LinkUrl]
           ,l.[CreationUserID]
           ,l.[LinkCreationDate]
           ,l.[LinkShortURL]
           ,u.[UserName]
from [Link] l inner join [User] u
on l.[CreationUserID] = u.UserID
left outer join [Link_OLAP] o on l.LinkID = o.LinkID
where o.LinkID is null