split delimited string column into a table rows

How to split delimited string column into a table rows in SQL Server Instance

One of the challenges that always comes up when dealing with data captured through the apps is parsing multi-value fields. Many apps have “check all that apply” checkboxes, and the data from those type of questions often logged as a single delimited (mostly comma) field value. For example, the values from a sections of check...Continue reading

BI Solutions

What is Business Intelligence

  The phrase “business intelligence” is thrown around a lot these days; but what exactly is “business intelligence” and could it be a valuable tool for your business?   Business Intelligence—often abbreviated BI—allows us to acquire raw data and then analyze and organize it so that we can extract meaning from it.  This process—called data servicing—lets us identify...Continue reading

Scroll to top