This is perfect Nevyn! I can't thank you enough. I tried it with several tables. This is the elegant solution that was eluding me. Cheers.

Every one of these specialty tables always.

Nevyn (3/1/2015)

---

The problem is here:

[Composite Score Eligible ] [nvarchar](255) NULL,

[Composite Score] [nvarchar](255) NULL,

[Composite Score PGS Percentage] [nvarchar](255) NULL,

[coremeasure] [bit] NULL,

[pediatric] [bit] NULL

These 5 fields at the end do not fit...

Thanks again Naveen and here the scripted out Rheumatology table:

USE [SpecialtyUplift]

GO

/****** Object: Table [dbo].[Rheumatology] Script Date: 3/1/2015 4:16:52 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Rheumatology](

[Uplift...

Thank you Nevyn. Your script is just what I was hoping for. I do have to admit that I don't know how to successfully change the offset. The...

Nevyn (2/28/2015)

---

Ok, I have thrown together a quick sample for you.

First, an explanation.

You need to do this with dynamic sql. One query builds a string that contains your actual...

pietlinden (2/28/2015)

---

I've been trying to figure out how to answer this for a couple of days at least...

I faced a situation like this once, but it was in Access...

Nevyn (2/28/2015)

---

Ok, now we are getting closer. Having some background is very helpful.

I am still a bit unclear from your comment as to whether you could use one report or...

Nevyn (2/28/2015)

---

Looking at your example more closely, we would also need a way to tell which columns we are unpivoting together (what is a value vs rank, what value belongs...

Thanks for the reply Nevyn.

I think it might help if you took a step back and explained what you are trying to achieve overall.

Sounds like you like your query fine...

I'm not sure if the question I posted a couple of days ago is asking about something that's not possible, too much extraneous detail to wade through to have time...

I'm honored that Joe Celko gave me advice! I have a couple of your books. I'm guilty of some of the things you mentioned but I have zero...

Thank you everyone. All your answers helped me with my question. The reason I was not able to just parameterize the date and quarter to solve the entire...

Luis Cazares: Hey, we all have to start somewhere. What would you suggest as the better way? Thanks.

dwain.c and mister magoo: Thank you! I will try your...

Great point. We are a small operation so far so it would be me solving the problem at 2AM. As this is my first use of SSIS, I...