SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.Survey
(
  createdate   date, 
  emailinvite  char(4),
  phoneinvite  char(4),
  smsinvite    char(4),
  surveyid     int
);

CREATE TABLE dbo.SurveyInvite
(
  sentdate date,
  id       char(4)
);

INSERT dbo.Survey VALUES
('20220201','12ab','12bc', null ,1),
('20220210','23be','45hg','45tr',2),
('20220220','65hg', null ,'89kj',3);

INSERT dbo.SurveyInvite VALUES
('20220201','12ab'),
('20220205','12bc'),
('20220210','23be'),
('20220214','45hg'),
('20220218','45tr'),
('20220220','65hg'),
('20220224','89kj');
10 rows affected

SET SHOWPLAN_XML ON;
-- original query 

SELECT 'Email' as Type,esi.sentdate,emailinvite as inviteid,s.surveyid
FROM Survey s
INNER JOIN SurveyInvite esi on s.emailinvite=esi.id

UNION 

SELECT 'SMS' as Type,ssi.sentdate,smsinvite as inviteid,s.surveyid
FROM Survey s
INNER JOIN SurveyInvite ssi on s.smsinvite=ssi.id

UNION 

SELECT 'Phone' as Type,psi.sentdate,phoneinvite as inviteid,s.surveyid
FROM Survey s
INNER JOIN SurveyInvite psi on s.phoneinvite=psi.id


Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4053.23"><BatchSequence><Batch><Statements><StmtSimple StatementText="-- original query &#xa;&#xa;SELECT &apos;Email&apos; as Type,esi.sentdate,emailinvite as inviteid,s.surveyid&#xa;FROM Survey s&#xa;INNER JOIN SurveyInvite esi on s.emailinvite=esi.id&#xa;&#xa;UNION &#xa;&#xa;SELECT &apos;SMS&apos; as Type,ssi.sentdate,smsinvite as inviteid,s.surveyid&#xa;FROM Survey s&#xa;INNER JOIN SurveyInvite ssi on s.smsinvite=ssi.id&#xa;&#xa;UNION &#xa;&#xa;SELECT &apos;Phone&apos; as Type,psi.sentdate,phoneinvite as inviteid,s.surveyid&#xa;FROM Survey s&#xa;INNER JOIN SurveyInvite psi on s.phoneinvite=psi.id" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="0.0846718" StatementEstRows="6.96141" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x7C69819C3F3EBD71" QueryPlanHash="0x57B8BAE3FF1C6A61" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="104" CompileTime="15" CompileCPU="15" CompileMemory="488"><MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="1600" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1486640"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-02-24T13:59:26.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000004_22AA2996]" Table="[Survey]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T13:59:26.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_22AA2996]" Table="[Survey]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T13:59:26.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_239E4DCF]" Table="[SurveyInvite]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T13:59:26.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_22AA2996]" Table="[Survey]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T13:59:26.04" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000005_22AA2996]" Table="[Survey]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T13:59:26.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_239E4DCF]" Table="[SurveyInvite]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="6.96141" EstimateIO="0.0112613" EstimateCPU="0.00013068" AvgRowSize="24" EstimatedTotalSubtreeCost="0.0846718" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1015"></ColumnReference><ColumnReference Column="Union1016"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1018"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="1"></MemoryFractions><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Union1015"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Union1016"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Union1017"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Union1018"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="7" EstimateIO="0" EstimateCPU="7e-07" AvgRowSize="24" EstimatedTotalSubtreeCost="0.0732798" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1015"></ColumnReference><ColumnReference Column="Union1016"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1018"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1015"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1016"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" Column="sentdate"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" Column="sentdate"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" Column="sentdate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1018"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="24" EstimatedTotalSubtreeCost="0.0244272" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" Column="sentdate"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="&apos;Email&apos;"><Const ConstValue="&apos;Email&apos;"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="3" EstimateIO="0" EstimateCPU="0.0178489" AvgRowSize="18" EstimatedTotalSubtreeCost="0.0244269" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" Column="sentdate"></ColumnReference></OutputList><MemoryFractions Input="1" Output="0.5"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" Column="id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[SurveyInvite].[id] as [esi].[id]=[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[Survey].[emailinvite] as [s].[emailinvite]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="4" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" TableReferenceId="1" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp><RelOp NodeId="5" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="7" EstimatedRowsRead="7" EstimateIO="0.003125" EstimateCPU="0.0001647" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0032897" TableCardinality="7" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" Column="sentdate"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" Column="id"></ColumnReference></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" Column="sentdate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[esi]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="23" EstimatedTotalSubtreeCost="0.024426" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" Column="sentdate"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="&apos;SMS&apos;"><Const ConstValue="&apos;SMS&apos;"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2" EstimateIO="0" EstimateCPU="0.0178478" AvgRowSize="18" EstimatedTotalSubtreeCost="0.0244258" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" Column="sentdate"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.5"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" Column="id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[SurveyInvite].[id] as [ssi].[id]=[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[Survey].[smsinvite] as [s].[smsinvite]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="8" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" TableReferenceId="2" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp><RelOp NodeId="9" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="7" EstimatedRowsRead="7" EstimateIO="0.003125" EstimateCPU="0.0001647" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0032897" TableCardinality="7" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" Column="sentdate"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" Column="id"></ColumnReference></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" Column="sentdate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[ssi]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="24" EstimatedTotalSubtreeCost="0.024426" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" Column="sentdate"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="&apos;Phone&apos;"><Const ConstValue="&apos;Phone&apos;"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2" EstimateIO="0" EstimateCPU="0.0178478" AvgRowSize="18" EstimatedTotalSubtreeCost="0.0244258" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" Column="sentdate"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.5"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" Column="id"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[SurveyInvite].[id] as [psi].[id]=[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[Survey].[phoneinvite] as [s].[phoneinvite]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="12" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" TableReferenceId="3" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp><RelOp NodeId="13" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="7" EstimatedRowsRead="7" EstimateIO="0.003125" EstimateCPU="0.0001647" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0032897" TableCardinality="7" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" Column="sentdate"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" Column="id"></ColumnReference></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" Column="sentdate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[psi]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></Hash></RelOp></ComputeScalar></RelOp></Concat></RelOp></Sort></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


SELECT i.sentdate, 
       [Type] = REPLACE(u.Types, 'invite', ''),
       inviteid = u.id,
       u.surveyid
FROM dbo.Survey AS s
UNPIVOT (Id FOR Types IN 
  (emailinvite, phoneinvite, smsinvite)) AS u
INNER JOIN dbo.SurveyInvite AS i ON u.Id = i.id;


Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4053.23"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT i.sentdate, &#xa;       [Type] = REPLACE(u.Types, &apos;invite&apos;, &apos;&apos;),&#xa;       inviteid = u.id,&#xa;       u.surveyid&#xa;FROM dbo.Survey AS s&#xa;UNPIVOT (Id FOR Types IN &#xa;  (emailinvite, phoneinvite, smsinvite)) AS u&#xa;INNER JOIN dbo.SurveyInvite AS i ON u.Id = i.id" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="0.0245574" StatementEstRows="8.1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x248025202E1DF3FF" QueryPlanHash="0xA619EAFAFBA4F1FC" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="56" CompileTime="0" CompileCPU="0" CompileMemory="312"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1056" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1486640"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-02-24T13:59:26.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000004_22AA2996]" Table="[Survey]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T13:59:26.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_22AA2996]" Table="[Survey]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T13:59:26.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_22AA2996]" Table="[Survey]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T13:59:26.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_239E4DCF]" Table="[SurveyInvite]" Schema="[dbo]" Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8.1" EstimateIO="0" EstimateCPU="8.1e-07" AvgRowSize="4022" EstimatedTotalSubtreeCost="0.0245574" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[i]" Column="sentdate"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="replace([Expr1008],N&apos;invite&apos;,N&apos;&apos;)"><Intrinsic FunctionName="replace"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;invite&apos;"></Const></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8.1" EstimateIO="0" EstimateCPU="0.0179281" AvgRowSize="150" EstimatedTotalSubtreeCost="0.0245566" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[i]" Column="sentdate"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[i]" Column="id"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1007"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[SurveyInvite].[id] as [i].[id]=[Expr1007]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[i]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="2" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="7" EstimatedRowsRead="7" EstimateIO="0.003125" EstimateCPU="0.0001647" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0032897" TableCardinality="7" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[i]" Column="sentdate"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[i]" Column="id"></ColumnReference></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[i]" Column="sentdate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[i]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[SurveyInvite]" Alias="[i]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp><RelOp NodeId="3" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="8.1" EstimateIO="0" EstimateCPU="3.42e-06" AvgRowSize="147" EstimatedTotalSubtreeCost="0.0033358" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="9" EstimateIO="0" EstimateCPU="3.762e-05" AvgRowSize="147" EstimatedTotalSubtreeCost="0.00333238" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference></OuterReferences><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0032856" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[Survey].[surveyid] as [s].[surveyid]"><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="surveyid"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="7" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="3" EstimateIO="0" EstimateCPU="3.157e-06" AvgRowSize="143" EstimatedTotalSubtreeCost="9.157e-06" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><ConstantScan><Values><Row><ScalarOperator ScalarString="N&apos;emailinvite&apos;"><Const ConstValue="N&apos;emailinvite&apos;"></Const></ScalarOperator><ScalarOperator ScalarString="[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[Survey].[emailinvite] as [s].[emailinvite]"><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="emailinvite"></ColumnReference></Identifier></ScalarOperator></Row><Row><ScalarOperator ScalarString="N&apos;phoneinvite&apos;"><Const ConstValue="N&apos;phoneinvite&apos;"></Const></ScalarOperator><ScalarOperator ScalarString="[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[Survey].[phoneinvite] as [s].[phoneinvite]"><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="phoneinvite"></ColumnReference></Identifier></ScalarOperator></Row><Row><ScalarOperator ScalarString="N&apos;smsinvite&apos;"><Const ConstValue="N&apos;smsinvite&apos;"></Const></ScalarOperator><ScalarOperator ScalarString="[fiddle_61e7e293e12441708cc1eb70e169b47a].[dbo].[Survey].[smsinvite] as [s].[smsinvite]"><Identifier><ColumnReference Database="[fiddle_61e7e293e12441708cc1eb70e169b47a]" Schema="[dbo]" Table="[Survey]" Alias="[s]" Column="smsinvite"></ColumnReference></Identifier></ScalarOperator></Row></Values></ConstantScan></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="[Expr1007] IS NOT NULL"><Logical Operation="IS NOT NULL"><ScalarOperator><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>