如何在条件下仅将一些 Guid 从一个表替换到另一个表

Question

我已经创建了一个视图，但我想将结果的一些 Guid 更改为另一个表中的 Guid，我想直接在我的视图中查看结果，我不知道怎么做？

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

您应该将表与具有另一个条件的目标 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