UNION ALL Optimization

Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.

Performing union data with null values

Random unions

Combining union and union all

Converting Access Queries with iff() and DLookup() to SQL Server

This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.

Changing the column order

Is there anyway of changing the order of the columns in table by using T-SQL.

RE: DELETE ignores WHERE clause containing invalid subquery

Intresting, where did you test and what version is your SQL Server (along with @@version info). I tried a couple of ways and could not duplicate the problem.

RE: Missing Data importing from Excel

Some info here, although not good news I'm afraid: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q236/6/05.asp&NoWebContent=1 If the workaround give here is unacceptable, you might be able to fudge it by applying a macro onto the excel sheet that explictly converts all numeric values to character data in the affected columns (I know you don't want to play these games if […]

RE: msSQL and SAGE line 100

Can you post the SQL code, or is it proprietary? Have you tried contacting the vendor for support?