10.093s✔
Given a new database and inserting tags and a link change the tag name, remains same name as tag
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