finally i used a proxy to browse the website. Got it. Thanks

Forbidden

You don't have permission to access /pages/mhp/content/help/error.html on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

I don't know why I can't access the URL :(.

I know but unfortunately i don't know why I can't have the access to that page. That's why I posted a question in the forum.

http://www.mhprofessional.com/product.php?isbn=0071548084

can you access the...

http://www.amazon.com/Microsoft-Server-2008-Reporting-Services/dp/0071548084

Inner join works perfectly fine. Thank you so much.

Inne Join works perfectly fine. Thank you so much.

Hi guys,

Finally came up with something. Please let me know if there is anything I can improve

select pivotTable.Item, ISNULL(pivotTable.jan,0) as jan, ISNULL(pivotTable.feb,0) as feb, ISNULL(pivotTable.mar,0) as march,

ISNULL(pivotTable.apr,0) as april, ISNULL(pivotTable.may,0)...

ok great. Will read it and come up with the answer.

that was the query I came up with. but I am stuck on the CTE part.

hello,

I could not ask for a better explanation than that.

Awesome explanation.

Thank you for your time and patience in writing all this.

Works like a charm.

Cheers,

Ashley