Miscellany

update MySport.dbo.Tmp_Tabs  -- Table to updateset MySport.dbo.Tmp_Tabs.Level=MySport.dbo.MS_Hierarchy.Levelfrom MySport.dbo.MS_Hierarchywhere 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*/