March 2011



Incorrect Language Detected in Word 2007

I don’t know what happened, but for some reason MS Word 2007 switched the language and every other word I would type would have a red line under it.  But this was only occurring in a  certain section, not the whole document.  When I right click the word to get the suggestions, Read More



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 when I had to move a query to a view.  The query: Using CASE in TSQL Use the CASE expression Thanks to: http://www.sql-server-performance.com/faq/iif_tsql_p1.aspx