Question populate data in gridview

[napii21]

Hi,

i need help. i have a table consist of 1 datetime column in sql server:

-------------------------
subject | date
-------------------------
a | 2012-10-11
-------------------------
a | 2012-10-11
--------------------------
a | 2012-10-13
-------------------------
a | 2012-10-14
-------------------------
a | 2012-10-14
-------------------------

the problem is i want view these data in gridview with this format:

----------------------------------------------------------------------------------------
subject | total | 2012-10-11 | 2012-10-12 | 2012-10-13 | 2012-10-14 | 2012-10-15
----------------------------------------------------------------------------------------
a | 5 | 2 | 0 | 1 | 2 | 0
---------------------------------------------------------------------------------------

can anyone help me please..

 

[jmcilhinney]

I've never done it myself but what you want is a pivot query.

https://www.google.com.au/search?q=...s=org.mozilla:en-GB:official&client=firefox-a