Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query
Hi guys, I would like to share an experience with you when I was working on 1 SSIS related issue. Scenario was: I have to exclude some records from Table A by matching some keys of Table B. Table A Year Month CustomerCode <Extra Columns> 2012 JAN CX1000 2012 JAN CX2000 2012 JAN CD3000 Table B Year Month RecCustomerCode <Extra Columns> 2012 JAN CX1000 2012 JAN CX7000 2012 JAN CD8000 What is expected was – Table A’s following records: Year Month CustomerCode <Extra Columns> 2012 JAN CX2000 2012 JAN CD3000 … Continue reading →