Monthly Archives: August 2012

Get first and last day of month in SQL 2012 and SQL 2008 and earlier

This article has been reviewed, improved and moved to my new blog http://blog.hubacek.uk/get-first-and-last-day-of-month-in-sql-2012-and-sql-2008-and-earlier/ Today I had to create an ETL for batch loading of records into data warehouse for the current month. For this I had to get first and last day … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , , , , , | 4 Comments

Use your text / CSV files in your queries via OPENROWSET

This article has been reviewed, improved and moved to my new blog http://blog.hubacek.uk/use-your-text-csv-files-in-your-queries-via-openrowset/ On Friday I was asked by my friend whether I could help him with text file access via OPENROWSET with Ad Hoc Distributed Queries. So I stopped by to … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , | 3 Comments