Hi All. The Business and Financial Management Peer Group is starting a weekly blog thought akin to the 12 Days of Business and Financial Management that we published in December last year. We hope this will be a useful tool for everyone.
I get the pleasure to kick things off, and I thought I'd piggy-back on a recent discussion in the Elite listserv on Elite and SQL. As we near the end of the year, odd-ball ad hoc requests often come up for various bits of data and/or full on reports for various cuts that are simple unavailable within the application itself. Many of you are aware of the blog I created many moons ago called
SQLforElite. Well, due to popular demand, and in the spirit of ILTA community, I've posted a few more items in the past couple days, and will post a new query each day this week. (So I guess this is a weekly thought of daily thoughts, ha!)
I'd also like to point your attention to the
initial post on the blog. The blog started with a webinar I presented for ILTA back in 2009 on mining the Enterprise database. In the post, there is a link to the presentation from that webinar which gives many of the basics of SQL and a brief overview on some of the main tables within Elite. If you're new to Enterprise, or new to querying Enterprise, this would be a great start.
Last, if your firm is not on Enterprise, I'd encourage you to still check it out as I often reference general SQL tips and techniques, such as using common table expressions, effectively and correctly using full, right and left outer joins, and efficiently using variables and temp tables to achieve your desired results.
Thanks, and I hope these posts will prove beneficial to many!
PS. If anyone would ever like to guest post for SQLforElite, drop me a line. I'd love to feature other folk's code as well!