Moving Access to SQL Server – Pivots 
While moving some MS Access Queries to a SQL Server View, I realized that SQL Server handles pivots quite differently than Access. Unfortunately in SQL…
Joshua DoodnauthApril 6, 2011
Using IIf in TSQL
Using IIF in Access I am currently moving a client from an Access DB to MS SQL Server 2008, and came up to a problem…
Joshua DoodnauthMarch 9, 2011