update MySport.dbo.Tmp_Tabs  -- Table to update
set MySport.dbo.Tmp_Tabs.Level=MySport.dbo.MS_Hierarchy.Level
from MySport.dbo.MS_Hierarchy
where MySport.dbo.Tmp_Tabs.TabID=MySport.dbo.MS_Hierarchy.fTabID


-- and tmp_MySport.dbo.MS_UserProfile.ImageName is not null


/*
insert into category_shoppingdotcom_mapping(category_id,shoppingdotcomid)
select category_id,shoppingdotcomid from tmp_shoppingdotcom where category_id is not null
*/