Remember those college days when your calculus professor will ask questions such as prove that cosine 90 is zero? No? Ok, take it easy, its not coming back to haunt you anymore. Have you ever thought writing SQL stored procedure with or without Begin End will execute differently? To be frank, I have never thought […]
SQL Server 2012 has introduced a nice function EOMONTH which gives end of month for a given date. How do you know how many days are in a month in real life? Well, for me, l still use the childhood song “30 days has September, April, June and November. All the rest has 31 except […]
This is a real scenario l had to deal with at work today. I had about thousand folders with multiple files and l wanted to move all these files to a folder on my network where an application will pick up the files and process them into my production database. I started googling for utilities […]
I came across the problem of using temp tables in stored procedures and selecting a result set from the temp table to return in SSIS 2012. I think it is very common using temp tables in stored procedures and to know that SQL server 2012 does not provide the same support for temp tables was […]