I am truly grateful for your generous assistance and patience.

I am getting this error:

The type of column "AvgResponseTime" conflicts with the type of other columns specified in the UNPIVOT list.

I...

Hi K Cline.

I know I am becoming a pain, despite your generosity with your time and assistance but if you could help solve this one last issue, I would really...

This is truly, truly incredible.

I have had some truly wonderful here since I discovered this forum and I appreciate every single one of them but this is remarkable.

I honestly didn't...

hi K Cline:

I must say that you have gotten me closer to solving this problem than anyone that I can think of.

I am very impressed and I thank you very,...

Thank you very, very much K Cline.

I will give this a go and let you know how it turns out.

Thank you very, very much K Cline.

I will give this a go and let you know how it turns out.

Thanks a lot K Cline for all the time you spent helping out on this.

I really, really appreciate it.

So, just looking at this code, it means that the user can...

Thank you for clarifying things for me.

They start Saturday - Friday, Then Saturday through Friday, etc

That's how they do it.

If that's what you mean by rolling week, then yes, you...

K Cline,

Thanks a lot for your interest in helping.

To answer your questions,

"Reporting Week" is defined as filling up an excel spreadsheet with data similar to what I showed in as...

As newbie as I am with SQL, I am beginning to feel a bit better because I thought this would be easy to seasoned veterans and I would be made...

This is what my expected results should look like:

Incident Type Reporting Week ...

Hi Lynn,

Here is sample data (3) that you can cut/paste

INSERT INTO FIB.dbo.FIREReportsData

(DataGroupID

...

Hi Lynn,

Ok sure.

Here is sample data. I just started; so not much data at all.

******

DDL

********

CREATE TABLE [dbo].[FIREReportsData](

[ReportQID] [int] IDENTITY(1,1) NOT NULL,

[StructuralFires] [int] NULL,

[Non_StructuralFires] [int] NULL,

[Non_Fire_Emergencies] [int] NULL,

[Fire_Alarms] [int] NULL,

[Hazardous_MaterialsRespIncids] [int]...

Lutz,

Your legend continues to grow everyday.

This worked like a dream!

Thank you very much.

You have bailed me out twice.

I hope I don't use up all of your good graces.

Again, thanks a...

Thanks again great people.

I can see that I have done it again!

I didn't explain myself well.

Let me attempt to represent the issue graphically.

For the purpose of what I am trying...