Not only I got it now. I just created my own new query in a different scenario. Man, it is so nice when there is a light at the end...

Well, that's is interesting to me as well, because I love learning. I really do.

Let me go over the code with you here.

ALTER PROCEDURE [dbo].[qryItemRank]

--===== Declare the I/O Parameters

...

I was suspecting something like that. Thank you for confirming it. Perfect. Thank you so much Jeff for all your work and contribution. I will use your code to convert...

I am trying but since I started this exercise I have shown little experience I will continue to be persistent in my ignorance. I do not really understand. :unsure:

Hey Jeff,

The code looks great. For some reason though the code return 543 rows while the access database query running on the same data set with the same parameters returns...

Hey Jeff,

How goes the battle? I am trying to figure things out on my end and I feel my efforts have been in vain. I hope yours are not.

I found...

Hi Jeff,

This is what I have when I check for the version value on my server

"Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 ...

Hi Jeff,

Attached is the screen capture for DATA_3, SKU_Content, and the query after I plugged in a replacement values for what you requested. I have at the bottom the actual...

Man, you get this right, and I am going to send you a cheque for some pizza money for sure or steak 😉

Hey Jeff,

I am confirming that both tables are identical.

Hi Jeff,

I am not in the office right now so I can't check to confirm. However, the Data_3 file in SQL Server was the up-sized table from the ACCESS database....

The screen capture was right after I ran that query with no modification. Isn't that odd? But anyhow, the output is what I care about to look like the screen...

Hi Jeff,

Here is a pdf of the the first few lines.

I really appreciate your help.

Thank you very much, Jeff. Here is the create statement for Data_3:

CREATE TABLE [dbo].[Data_3](

[Market] [nvarchar](255) NOT NULL,

[Tag] [nvarchar](255) NOT NULL,

[Fact] [nvarchar](255) NOT NULL,

[P25] [real] NULL,

[P24] [real] NULL,

[P23] [real] NULL,

[P22] [real]...

Thanks. This code is written in VBA Access. I have been reading much about PIVOT code over the past four days without luck to solve this. I appreciate your humor,...