Monthly Archives: November 2015

SQL View to produce descriptive one-parameter date ranges

Automatically generated date ranges by name. Year-to-date? Last month? Next month year-to-date? Last fiscal year? Last calendar year? Auto-calculated using a view? Bam. http://www.sqlservercentral.com/articles/SSRS/133147/

Posted in Programming, SQL Server | Leave a comment

MS Project hotkeys

Explode/Implode all: Click upper left corner to select all, then ALT-SHFT-Hyphen to implode, or ALT-SHFT-PLUS repeatedly to explode. Bump selected tasks in/out: ALT-SHIFT-Left/Right Arrow. Thanks: http://www.msofficegurus.in/2010/10/ms-project-keyboard-shortcuts/ and: https://support.office.com/en-us/article/keyboard-shortcuts-for-project-2010-2921ef72-56e4-44ef-9d5c-ab7cf3a703d1

Posted in Project Management | Leave a comment

MS-Word Style Formatting codes and hotkeys

Reveal codes Selected SHFT-F9 All ALT-F9 Goto next field F11 Show Styles / Reveal Formatting SHFT-F1 Edit Bookmark CTRL-SHFT-F5 File / options / Advanced | Show document control – show bookmarks Display the bookmark indicators. Remove all special formatting CTRL-A … Continue reading

Posted in Office, Word 2007 | Leave a comment

Snow White

We were watching Snow White with the girls. After the “Whistle while you work” scene in which Snow White coordinates the activities of a flurry of forest creatures to clean the Seven Dwarves’ home, our 8-year-old observed, “Snow White was rather … Continue reading

Posted in Parenting, Quote of the Day | Leave a comment