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

bigatorMay 21, 2014 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , ,  · Posted in: General, Interview QA, SQL Server

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 […]

bigatorJanuary 25, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , , , , ,  · Posted in: Business Intelligence, Free, General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, SSIS, T-SQL, Tutorial

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. […]

bigatorMay 9, 2012 · bigatorKhilitchandra Prajapati · bigator3 Comments
bigatorTags: , , , ,  · Posted in: General, Interview QA, Quick Tips, SQL Server, Tutorial