Here’s a quick T-SQL tip for you.Suppose you want to swap the year part of a date value in SQL server. Here’s a quick and simple way in which you can do it.Lets consider the below example DECLARE @DateValue datetime ,@SwapYear…
T-SQL Tips: Get The Weekday Number of the Month
I’ve added a new utility function in Technet Wiki to retrieve the number of week day for the month for the date passed ie say 13 Apr 2014 is 2nd Saturday,15th jan 2013 is 3rd Tuesday etc. Do check it…
SSIS Tips: Implementing Conditional Logging
The impetus for this post comes from a recent conversation I had with one of my colleagues. He asked me whether we could implement logging conditionally for a SSIS package. I told it should be possible keeping in mind that…