Different seed after IDENTITY INSERT in SQL Server 2012 and SQL Server 2008 Christian Donner, May 21, 2015May 21, 2015 Once something takes more than an hour to figure out, it is always a good… Continue Reading
T-SQL: replace occurrences of two or more characters in a row with a single new character Christian Donner, May 31, 2013May 31, 2013 Here is a T-SQL UDF that replaces occurrences of two or more characters in a… Continue Reading
Business Intelligence Showcase by pod consulting Christian Donner, May 27, 2009January 26, 2014 The Business Intelligence Showcase demonstrates our expertise with Microsoft’s business intelligence application suite. These technologies… Continue Reading
Setup projects with SQL Server Compact Edition (CE) databases Christian Donner, April 12, 2009August 19, 2009 This article is no longer relevant. In Visual Studio 2008 SP1, setup projects allow you… Continue Reading
Free mileage tracker with desktop import for Windows Mobile 6 Smartphones Christian Donner, April 12, 2009December 8, 2011 It is finally ready – the new and improved TripsNMiles, pod consulting’s free mileage tracker for the Windows Mobile platform. Continue Reading
Combining contiguous date ranges in a SQL query – using CTE recursion Christian Donner, November 6, 2008April 12, 2009 Sometimes we need to reduce the granularity of date ranges by combining serveral contiguous rows… Continue Reading
DateTime comparisons in SQL Server 2008 and 2012 Christian Donner, August 28, 2008December 2, 2015 The issue is that SQL Server’s DateTime data type appears to be able to resolve… Continue Reading
SQL Server 2005 – Recursion Christian Donner, May 3, 2008April 12, 2009 Why do I find all the examples of how to use recursion in SQL Server… Continue Reading
Using SQL Server Column Aliases Christian Donner, March 14, 2008January 12, 2013 When you have a query that does complex calculations, maybe even has function calls in… Continue Reading