I have two files each with one column, which is a simple unique ID.
One file is a subset of 1,196 IDs from the larger file of 1,504 IDs, the difference = 308.
I am simply trying to determine which 308 IDs are missing from the original file.
I have tried two methods,
SELECT * FROM RiskAdjust_Temp.dbo.PROF_ID_Tmp /1,196/
SELECT * FROM RiskAdjust_Temp.dbo.PROF_ID_Tmp1; /1,504/
In that method I have reversed the tmp files and the results bring back either the 1,196 IDs or I get all 1,504 IDs returned.
FROM RiskAdjust_Temp.dbo.WHP_CPP_PROF_CCs a
WHERE a.“Prof Mem ID” not in (select “Prof Mem ID” from RiskAdjust_Temp.dbo.PROF_ID_Tmp b);
SELECT COUNT() AS NumberOf FROM RiskAdjust_Temp.dbo.PROF_ID_Tmp1; /= 0 something wrong*/
In that method I am getting back 0 IDs.
Any ideas or suggestions would be most appreciated.