if you want to update this in table. you need something likeUPDATE tSET t.edge_weight = tmp.edge_weightFROM [socialDB].[dbo].[final] tINNER JOIN(SELECT [socialDB].[dbo].[final].[author_key_from] ,[socialDB].[dbo].[final].[author_key_to],COUNT(*) AS "edge_weight"FROM [socialDB].[dbo].[final]GROUP BY [socialDB].[dbo].[final].[author_key_from] ,[socialDB].[dbo].[final].[author_key_to])tmpON tmp.[author_key_from] = t.[author_key_from]AND tmp.[author_key_to] = t.[author_key_to]
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/