As we get ready to turn the page on another year, what steps are you taking to set your business up for success? Your data is central to your business and having the right analytics in place to capture and interpret this data is critical. To help you prepare, we compiled a list of questionsRead more
I recently worked on a project that used web services to feed information to the SSRS reports that were created for the various business segments at this particular organization. Stemming from that project, this blog post will present how to create a simple web service that returns a serialized dataset and a simple SSRS reportRead more
Introduction Many software applications present formatted data to the user via user interfaces and reports. Often times the code that formats the data is difficult to read and maintain. This blog will briefly touch on a new C# 6.0 feature, String Interpolation, to format string data. In many cases, using string interpolation reduces the sizeRead more
Scenario When running a query, many times there are instances where there is non-existent data. The following blog addresses various scenarios and solutions for overcoming this issue. A hospital report needs to show Intentsive Care Unit (ICU) bed occupancy by date. The WITH statement below simulates a small table of source data so you canRead more
One of our clients at SCS recently needed to compare two sets of financial results – specifically, to see if they were the same. The client calculates its sales commissions on a monthly basis, and they suspected the final week of a previous month actually had consistently higher sales. This line of thinking makes sense,Read more
