Posted for future reference. This article by Jeff Smith “covers different ways to create sequence numbers. It starts with the basic identity and GUIDs and quickly moves to much more complicated sequence numbers including those with auto-incrementing mixed letters and numbers such as “A0001″, etc.”
Archive for April, 2007
Custom Auto-Generated Sequences with SQL Server
April 26, 2007New home
April 25, 2007Thanks to a nice wordpress.com feature you can now access this blog at blog.srlanger.com. I did things this way (instead of hosting WP myself) since it saves me from the hassles of maintaining the software – while still attributing links to a domain that I own. See you there!
Excel and accounting-related blogs
April 13, 2007I just happened to discover the Accounting Mechanics blog which focuses on “tools and techniques of the management accountant” and happens to have a link back to my own blog. I’ll catch up with posts there as soon as possible since there seems to be quite a few interesting articles. I’ve already spotted the following:
There’s also a link to another potentially interesting blog, that one focusing on “professional spreadsheet development stuff”.
Several great Excel-related articles
April 4, 2007Charles W. Kyd has posted several great articles on his ExcelUser website:
- How to Summarize Excel Data For Reporting and Analysis
- Excel Shortcut Keys Offer Quick Access to Dialogs
- Show Key Stats Automatically In Periodic Excel Reports
If you spend your days working with Excel, you’ll want to subscribe to Charles’ Excel for Business newsletter.
MS Access to SQL Server SQL dialect cheatsheet
April 2, 2007Thinking of migrating the database portion of your Access-based (JET SQL) solution to SQL Server (T-SQL)? Well Jeff Smith just posted a quick MS Access (JET SQL) to SQL Server (T-SQL) Cheatsheet to help you in this process.
