sql - 如何在条件下仅将一些 Guids 从一个表替换为另一个表

Question

我已经创建了一个 View ，但我想将一些结果的 Guid 更改为来自另一个表的 Guid，我想直接在我的 View Result 中使用它，但我不知道如何做？

select  p.[Guid], c.[Guid] detailsGuid
INTO #temp1
from 
ret_PayrollCalculationCommands s INNER JOIN
ret_PayrollCalculations p  ON p.CalculationCommandGuid = s.Guid INNER JOIN
ret_vwPayrollCalculationDetails c ON c.CalculationGuid = p.Guid

Answer 1

你应该 INNER JOIN 你的表与具有目标 Guid 列的同一个表与另一个条件:

SELECT 
    p.[Guid], 
    c.[Guid] detailsGuid,
    pMainCalculation.[Guid] AS [TargetGuid]
INTO #temp1
FROM 
    ret_PayrollCalculationCommands s INNER JOIN
    ret_PayrollCalculations p  ON p.CalculationCommandGuid = s.Guid INNER JOIN 
    ret_PayrollCalculations pMainCalculation ON pMainCalculation.CalculationCommandGuid = p.CalculationCommandGuid AND pMainCalculation.MainCalculation = 1 INNER JOIN
    ret_vwPayrollCalculationDetails c ON c.CalculationGuid = p.Guid