Sure Lutz!

Here they are.

First, the insert script is inserting a bunch of duplicates.

I wanted to insert each record for each date range.

I am not sure how to do that, other...

Jeff,

Man, you are right!

Trust me; I swear with my hand on a stack of bibles, I ran the create table, the insert and the query and they all worked....

Once again, my apologies Lutz.

I have fixed them up and have been able to generate data.

Please see entire scripts from Createtable, to insert, to query.

If (OBJECT_ID('dbo.HHSDataTest', 'Table') Is Not Null)...

Here is the sample data generated by the code:

Incident Type ...

hi Lutz,

If you scroll up, you will see where I have Week1, Week2, etc.

That's my expected result.

In other words, if I get the code working, it will will show YTD...

Hi Jeff,

Hopefully, I have followed the best practices as described on the link you provided.

Here is some sample data.

First one creates 2 tables, HHSReportsdata which holds data for each week....

Thanks a lot for your help. It is much appreciated.

Hopefully, you wouldn't mind me asking a separate question on same thread.

When I export data to PDF, I see extra blank page.

So, instead of one page, it shows 2 pages,...

Ok, sorry my fault.

I set the the length at nvarchar(150) programmaticall and that was the problem.

Sorry about that.

Thanks for your prompt response.

Here is an example of what is going on. The following text is inserted into the database:

The ID Blvd near Interstate 20 is currently experiencing quality...

Thanks a lot. Everything is working now.

I really appreciate it.

It is WORKING sir!!!!!!

I will NEVER, EVER forget this, EVER!

Thank you, very, very much.

Thank you K Cline. THANK YOU SIR!

So, I can just perform the following action just ONCE, right?

Create...

K Cline,

Even my father, the most patient man I know, will NOT be as patient as you have been with me so far and I worry but I may be...

Thank you very much sir for all this work.

I really, really appreciate it.

The one BIG issue that I have is still not resolved and that is the issue of generating...

You are simply the BEST.

Many, many thanks.

I understand your comments about making the unpivot column names to nvarchar(150).

Did you change the datatypes on the db side as well?

I am getting...