SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2010

Flipping a Table Sideways

Not too often, someone asks for a strange request like wanting to pivot on every single value inside a table. No aggregations at all, just a listing of the columns as shown in the screenshot below. This happened for a colleague of mine recently. As such, a few of us… Read more

0 comments, 1,453 reads

Posted in BrianKMcDonald on 28 May 2010

Using PATINDEX to Split Column Data

A colleague of mine received an Excel file that he needed to load into a table for future lookup values. There were some crazy columns containing multiple values inside one cell, which he needed to split up into multiple columns. Seems pretty straight forward so far right? And a pretty… Read more

0 comments, 672 reads

Posted in BrianKMcDonald on 20 May 2010

Using the Report Items Collection in Reporting Services

Using the Report Items Collection in Reporting Services

Sometimes, you may want to do calculations or use some value that has already been used in another object. By using the report items collection, you can get the value from whatever object you want and use it in a calculation.

For… Read more

0 comments, 454 reads

Posted in BrianKMcDonald on 12 May 2010

SSRS - Time Saver using Templates

Creating a Reporting Services Template

Many companies like to have a consistent look and feel across their applications. Some even make them part of the standards. As such, one may want to create a reporting services template that allows them to start off the report with objects or properties set… Read more

0 comments, 523 reads

Posted in BrianKMcDonald on 12 May 2010

Running Totals Using Reporting Services

Sometimes one may need to see a running number that represents a quantity for a period of time. For example, let’s say you have a month to date report that breaks out the quantity of units sold on a daily basis. And you get a request from the Sales Manager… Read more

0 comments, 1,428 reads

Posted in BrianKMcDonald on 12 May 2010

SQL Saturday 38 Presentation

This past weekend was SQL Saturday 38 in Jacksonville Florida. It was a great event and the turnout was incredible. My presentation was first thing in the morning and as such, I enjoyed the opportunity to pass on some of my experiences with SSRS. I had a ton of material… Read more

0 comments, 371 reads

Posted in BrianKMcDonald on 12 May 2010

Time Matters: Part 1

If you’re anything like me, you value every second of your day and you constantly try to find new ways to maximize your time. And since I find myself on the road between here and there; and there and here quite a bit lately, I really need to be as… Read more

0 comments, 434 reads

Posted in BrianKMcDonald on 10 May 2010