INSERT INTO [Performance].[dbo].[F_Performance_CoreMG_Static] ([TimeID] ,[ProjectID] ,[StageID] ,[TaskID] ,[Value]) SELECT HM.MemberId ,HP.MemberId ,HS.MemberId ,HT.MemberId ,ABS(CONVERT(SMALLINT,CONVERT(BINARY(8), NEWID()))) FROM [Performance].[dbo].[H_Project_Project] HP INNER JOIN [Performance].[dbo].[H_Stage_Stage] HS ON 1 = 1 INNER JOIN [Performance].[dbo].[H_Task_Task] HT ON 1 = 1 INNER JOIN [Performance].[dbo].[H_Time_Months] HM ON 1 = 1