Adding the time zone

DateTimeOffSet to Character

The implicit datetimeoffset

Offset Hours

DateTimeOffset

INSERTing datetimeoffsets

The SQL Server 2008 Datetimeoffset Data Type

The Datetimeoffset Data Type was introduced in SQL Server 2008 (and .Net Frameword 3.5) and is the most advanced date and time date type available.

RE: Missing msdtc.exe

You're right Vidas thanks, I found it under the winnt\system32 directory.  The service was previously pointing to an old empty MSSQL\BINN directory for some reason which led me down the path of assuming it was part of SQL Server Cheers 

RE: CONVERT error - Money to Varchar

Actually it will work, if the following line is modified:DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar','numeric') So by adding ,'numeric' I can search numeric field types also.  I need to search money field types.  When I add the money type, I get an error from the part of the stored procedure I listed in the first […]

RE: Select an aggregate list?

You can do it without a UDF! However, reading this nice little code code by SQL Server Adam Machanic http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true the question is rather, why?