March 2009
2 posts
notes to self
for severity, found negative correlation between location and month.
PD losses seem like lit - not indep. of loss/dev
SQL Server note: BETWEEN is inclusive of the two... →
January 2009
6 posts
Excel: equivalent of VLOOKUP with multiple... →
I found myself coming back to this example today.
CASE statement - handy for finding the minimum of... →
“I needed to calculate the difference between two date fields today.
cast(...”
– DATETIME data type arithmenic in SQL Server 2005 - MS SQL
replacing newline characters in a spreadsheet
wanted to remove newline characters / carriage returns from inside of cells in a spreadsheet.
First, I needed to determine the character code of the newline character. I pressed F2 to enter cell edit mode and selected just the newline character, copying and pasting the character into a new cell. I used CODE() to determine the character code - it was 10.
I could then use SUBSTITUTE(<source...
SQL Server Management Studio - exporting fields... →
I found Aaron Bertrand’s comment on February 23, 2007 at 7:56 AM on his own post tremendously useful for exporting data from SQL Server Management Studio to Excel.
Under “Tools | Options | Query Results | SQL Server | Results to Grid”, I recommend checking “Quote strings containing list separators when saving .csv results”. Without this option selected, fields...
my intentions for this blog
i intend to use this blog to record notes about things i learn at work that might be useful to others doing similar things. i expect topics will center around accessing data (from SQL Server, Access, etc.), manipulating data (with SQL, Excel, R, etc.), analyzing data / Econometrics (with SAS, R, Excel, etc.), and sharing findings (with Excel, PowerPoint, R, etc.).
note: I do not prefer...