Till SQL 2008 VALUES clause was used only in conjunction with INSERT statements to insert values to a table. Starting from SQL 2008 onwards functionality of VALUES clause has been extended which enables it to be used in many scenarios…
Package to Implement daily processing of files from a remote folder
Of late, there were couple of instances where I was asked by fellow developers for solution which provides mechanism of daily processing of files coming in a remote folder. This is a typical scenario that we come across in any…
Implementing multiple table based check constraints
A common scenario we come across is the requirement to implement a constraint on a table to enforce a business rule based on another table. Though this can be implemented by means of trigger its not so efficient at times…
Julian to iso date conversion function
Recently I had helped out a friend on logic for converting Julian date value to iso date value in T-SQL. Julian dates are in format CYYDDD where C will denote century YY year and DDD the day of year. So…