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 :w00t:
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/