Monday, June 16, 2014

Sql Check if Object Exists


You know those situations where you want to drop and recreate something, or create something if it doesn't exist?  You can use the object_id function to check if an object exists in the database.

Monday, June 9, 2014

SSAS Dynamic Prior Period


When using the prior period function and you want the calculation to work on any level of the hierarchy, you'll need to remember the "CurrentMember.Level" syntax: