Can you tell me how the following two queries compare please.
PLEASE NOTE: You have not aliased all your columns so I have no idea which tables they come from. You must edit the following queries to remove any non-aliased columns that are not from vwREPQICASSCostsByCC.
SELECT
fldConsulNo,
fldConsulName,
fldCCGroupCd,
fldCCGroupDesc,
fldCCSortOrder,
fldCCDesc,
fldSubCCNo,
fldSubCCName,
v.fldCostCenterKey,
fldAmount
v.fldPlanKey
v.fldCostCenterKey
v.fldConsulKey
v.fldSubCostCenterKey
FROM
vwREPQICASSCostsByCC v
WHERE
v.fldStageKey = 4
AND v.fldPLanKey IN (30472);
SELECT
fldConsulNo,
fldConsulName,
fldCCGroupCd,
fldCCGroupDesc,
fldCCSortOrder,
fldCCDesc,
fldSubCCNo,
fldSubCCName,
v.fldCostCenterKey,
fldAmount
v.fldPlanKey
v.fldCostCenterKey
v.fldConsulKey
v.fldSubCostCenterKey
FROM
vwREPQICASSCostsByCC v
WHERE
v.fldStageKey = 4
ANDv.fldPLanKey IN (SELECT X.fldIMPPlanKey FROM #tmpPlan X);