Friday, October 31, 2014

SQL Derived Table from Values


So you have a small set of data you want to use in a query.  The data is static and temporary in nature so you don't really want to store it in a table.  A derived table from values might do the trick!

Monday, October 27, 2014

Install MDS Plugin for Excel 2010


So, you were attempting to install the Master Data Services Plugin for Excel, but couldn't get the install to actually process due to it saying the prerequisites are not installed:
Prerequisites Message
You have made sure you have the right version (32 bit) to match the version of excel (2010), and have the full version of .net 4.5 installed. If you try to install the full version of .net 4.0, you are told that the newer (4.5) version already is installed.