Link to home
Start Free TrialLog in
Avatar of arunatata
arunatata

asked on

Need help with OLAP views

Hi,

In response to a question I had posted in the ASP section, one of the experts had suggested that I use an OLAP view to get the data in the format I wanted it. The link to this question is as below. Can anyone help?

https://www.experts-exchange.com/questions/21402306/Need-help-extracting-data-from-a-database-for-a-specific-display-format.html

Thanks,
A.

Avatar of Jokra_the_Barbarian
Jokra_the_Barbarian
Flag of United States of America image

You cannot have more than 500 points for any one question. You will have to close the previous question or reward points for it if you want to keep this one open.
Avatar of rafrancisco
rafrancisco

Try this link on how to TRANSFORM your table.

http://www.sqlteam.com/item.asp?ItemID=2955
Avatar of arunatata

ASKER

Unfortunately I am not able to figure this one out - can you be more specific to my code?

Thanks,
A.
ASKER CERTIFIED SOLUTION
Avatar of rafrancisco
rafrancisco

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial