PASS Business Analytics Conference Day 2 Takeaways

Context: I’m a developer who has spent my entire career building transactional and day-to-day operational solutions. I’m attending PASSBAC to get some exposure to this problem area and technology stack. Takeaways: 1) Steven Levitt gave an entertaining keynote. Three main points: 1. Data analysis will become more and more important to businesses; 2. There are not enough people to do this type of work; 3. Business leaders have to want Read More...

PASS Business Analytics Conference Day 1 Takeaways

Context: I’m a developer who has spent my entire career building transactional and day-to-day operational solutions. I’m attending PASSBAC to get some exposure to this problem area and technology stack. Takeaways: 1) Excel/PowerPivot/PowerView are badass. Top of my list when I get home is to play around with this stack. 2) What is BI and what is the role of the developer in BI projects? My current answer: BI is Read More...

How to Use a List of Values in a SQL Server IN Clause

A somewhat common requirement is to use a list of integer IDs in an IN clause as shown below. USE AdventureWorks2008R2 GO declare @listOfIDs varchar(max) set @listOfIDs = '43662, 43664, 43667, 43676' select h.SalesOrderID , h.OrderDate , h.SalesOrderNumber , h.AccountNumber , h.TotalDue from Sales.SalesOrderHeader h where h.SalesOrderID in (@listOfIDs) Unfortunately, the query above returns the error below. Conversion failed when converting the varchar value '43662, 43664, 43667, 43676' to data Read More...

How to Pivot Data in SQL Server, Old-School Style

There are a handful of common requirements that lead SSRS report authors to seek the help of SQL developers and query writers. One such requirement is pivoting data. Pivoting data displays rows as columns, at least that’s how most people describe it when asking me for help. For example, a common way managers want to consume sales data is to have a row for each sales person and a monthly Read More...

How to Pivot Data in SQL Server, New-School Style

There are a handful of common requirements that lead SSRS report authors to seek the help of SQL developers and query writers. One such requirement is pivoting data. Pivoting data displays rows as columns, at least that’s how most people describe it when asking me for help. For example, a common way managers want to consume sales data is to have a row for each sales person and a monthly Read More...