T-SQL Tip : Finding Running Total Value
Hi Guys, In one of my SSRS Reporting needs, I need to display RunningTotal in some funny colors. Here is the script that I have used. I hope it may help you somewhere too 🙂 Thanks, Khilit
Continue reading →Tag Archives: T-SQL
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 →
Adding a new column to an existing table??? Check the rules first
Hi All, So, you are standing at the gates where you need to add a new COLUMN to an existing table. Well, there are 2 cases: Table is empty Table contains data If “Table is empty” then you are still in design-phase of that table. Add new column whichever the way you know 🙂 E.g. Using T-SQL or through design mode of table etc.
Continue reading →