This blog is to explain a limitation with CASE ..WHEN construct when used in a linked server query which I recently came across.So the scenario was this. I had a table in a remote SQL Server instance from which I…
T-SQL Tips: Get Business Weeks For a Month
Recently in one of my reporting projects, we required generating a list of business weeks along with the start and end dates for a given month so as to consolidate the data and do some weekly calculations on it. I…
SSDT Tips: Display Precedence Labels in SSIS 2012 Packages
Here’s a quick tip regarding SSIS development using SQL Server Data Tools 2012Couple of days before I heard one of my fellow teammates complaining about difficulty in identifying type of precedence constraint in SSIS like whether its for success,failure etc.…