Archive for July, 2007

UTC Date format

Tuesday, July 31st, 2007

Date and Time Formats

The UTC date format should look something like this.

UTC is Coordinated Universal Time.  I’m not sure why the letters are not in the same order.

Wikipedia has more info on it over at Wikipedia UTC 

Extensible Stylesheet Language Transformation XSLT: XSL to Excel how to apply AutoFit to Column ?

Tuesday, July 31st, 2007

Extensible Stylesheet Language Transformation XSLT: XSL to Excel how to apply AutoFit to Column ?

An example of using Excel XML Sheets.

Jul29_0005.jpg

Sunday, July 29th, 2007



Jul29_0005.jpg

Originally uploaded by jeffld.


Jul29_0004.jpg

Sunday, July 29th, 2007



Jul29_0004.jpg

Originally uploaded by jeffld.


Jul29_0003.jpg

Sunday, July 29th, 2007



Jul29_0003.jpg

Originally uploaded by jeffld.


Jul29_0002.jpg

Sunday, July 29th, 2007



Jul29_0002.jpg

Originally uploaded by jeffld.


Profile for Jeff Darling – Pandora

Tuesday, July 24th, 2007

Profile for Jeff Darling – Pandora

Want to see what music I listen to?  

DataType Enumeration Microsoft.SqlServer.Dts.Runtime.Wrapper

Tuesday, July 24th, 2007

DataType Enumeration Microsoft.SqlServer.Dts.Runtime.Wrapper

I may need to reference this later in order to debug a problem with the CRLF on a file exported from MS SQL server.  For some reason, the file that I’m getting does not have carraige return line feed and I’m not sure why. The Sender of the file is claiming that the file uses fields with Data Type  Unicode string [DT_WSTR] for the CRLF and string [DT_STR] for all the other fields on the record. 

I suspect the problem has to do with the Unicode encoding, but I’m not sure at that point.

Jul20_0001.jpg

Friday, July 20th, 2007



Jul20_0001.jpg

Originally uploaded by jeffld.


Microsoft Excel Spreadsheet Software: Nslookup in Excel

Wednesday, July 18th, 2007

Microsoft Excel Spreadsheet Software: Nslookup in Excel