MDX and DAX Query Formatter …. is back :)
Hi Friends, Just to share with you quickly that “MDX and DAX Query Formatter” site is back online. Here is the link: http://formatmdx.azurewebsites.net/ Thanks, Khilit
Continue reading →Tag Archives: Query
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 →