DECLARE @rowid uniqueidentifier > SET @rowid = NEWID() > INSERT INTO ProductFileData > (ProductFileColumnId,ProductFileRowId,ProductFileId) > SELECT INSERTED.Id,@rowid,INSERTED.ProductFileId > FROM INSERTED INNER JOIN ProductFileData ON ProductFileData.ProductFileId = INSERTED.ProductFileId>
INSERT INTO ProductFileData (ProductFileColumnId,ProductFileRowId,ProductFileId) SELECT INSERTED.Id,NewID(),INSERTED.ProductFileId FROM INSERTED INNER JOIN ProductFileData ON ProductFileData.ProductFileId = INSERTED.ProductFileIdOr why not let ProductFileRowID field to have default NewID() and then you don't need to include it in insert?