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 was a typical introduction to programming question. Create the pattern of a chess board that is 8 x 8. Use X and O to represent the squares. This is what your output should look like. XOXOXOXO OXOXOXOX XOXOXOXO OXOXOXOX XOXOXOXO OXOXOXOX XOXOXOXO OXOXOXOX Below is a simple code l wrote to get this output. This […]
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 […]