Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

trying to create a table - unpivot Expand / Collapse
Author
Message
Posted Tuesday, October 8, 2013 11:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
astrid 69000 (10/8/2013)
Thanks for your help.

I did a few changes on the query, but i am still encountering a few problems.
it is not summing the clickcount, i do get a three dimensional table like a wanted but without any measures
and also the table is dynamic and i dont know how to make the name of the columns dynamic where it will show the date it is checking.



The link that Luis posted above will show you, or you can follow the link in my signature about dynamic cross tabs.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1502743
Posted Tuesday, October 8, 2013 12:03 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, August 9, 2014 2:22 AM
Points: 53, Visits: 101
I will prepare a litter of coffee and sit down for some light reading

thanks to you too so much for your help.

I will let you know how it went.
Post #1502752
Posted Tuesday, October 8, 2013 12:52 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
astrid 69000 (10/8/2013)
I will prepare a litter of coffee and sit down for some light reading

thanks to you too so much for your help.

I will let you know how it went.


You are quite welcome. Post back if you run into issues and we can help you over the hump. This stuff isn't easy to wrap your head around at first but if you stick with it you will get it.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1502768
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse