Tricky SQL Query : Is it possible? : <p>I am not exactly sure how to ask this. I have a table with the colums, timestamp,user,and another field. Looking like below:</p>

<pre>
<b>USER,TIME,FIELD</b>
USR1,MON,VALUE1
USR1,TUE,VALUE1
USR2,MON,VALUE1
USR2,MON,VALUE2
USR1,MON,VALUE1
</pre>

<p>There is no upper level to the amount of users, they can be added on the fly and there is no naming convention. What i want to do is make a select statement, and get something like be this:</p>

<pre>
            <b>USR1,USR2</b>
MON,VALUE1:  2    1
MON,VALUE2:  0    1
TUE,VALUE1:  1    0
</pre>

<p>Is that possible?</p>

<p>I'm using MSSQL</p>

<p>Thank you in advance.</p>
