Simple SQL Server Version Control

Simple SQL Server Version Control

Ben Daland Business Analytics Specialist John Daniel Associates, Inc. Ben’s Profile Tracking changes for projects is very important and allows us to revert back to previous versions. There is out-of-the box software to handle source control, but not all environments are equipped or disciplined enough to handle full version control–especially SQL objects, which can be changed with a simple F5 while applications are running. In […]

Read Me

Comparing SQL Server Tables – Columns & DataTypes

Comparing SQL Server Tables – Columns & DataTypes

Ben Daland Business Analytics Specialist John Daniel Associates, Inc. Ben’s Profile Recently I was working on a project that had many different input tables that needed to be filtered into one. I’ve worked on similar projects before and it’s usually not too bad to compare a few tables. But this time, with so many different tables, using my normal approach would have been too time-consuming. […]

Read Me

Use a Variable in a TM1 TI Process SQL Statement to Filter on Input from a User

Use a Variable in a TM1 TI Process SQL Statement to Filter on Input from a User

Erin Dunmire Business Analytics Specialist John Daniel Associates, Inc. Erin’s Profile Variables can be used in a variety of ways in Turbo Integrator processes. The use of variables can increase efficiency by making the administration of your TM1 model easier. Variables can also play a role in providing an end-user with the ability to perform administrative tasks similar to typical user input. Many times SQL […]

Read Me

SQL Server PIVOT and UNPIVOT – with Sample Code

SQL Server PIVOT and UNPIVOT – with Sample Code

Ben Daland Business Analytics Specialist John Daniel Associates, Inc. Ben’s Profile This article will go over how to transform distinct column values into columns and transform columns into distinct column values using the PIVOT and UNPIVOT function. There are 2 different ways to use these functions – static and dynamic. The static approach is used when the distinct columns or column values are known. If […]

Read Me