Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.80K
1 Posted Topic
Below query for comparing 2 tables and extract the uncommon like GUID X121 doesn’t exists in the 2nd table and the GUID which are unsuccessful (has –ve values). select isnull(pt.GUID,Wo.GUIS)as GUID, pt.[ErrorNo] as Error from PieTreace pt full outer join WorkMessage Wm on pt.GUID = Wm.GUID where(pt.GUId is null) or …
The End.