🚀 go-pugleaf

If you know in advance the number of columns in the result set, try:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175574.

If you have a variable number of columns, try:
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15608

If you want some interesting utilities to do it for you, try:
http://www.ag-software.com/AGS/xp ags crosstab.asp

RAC at:
www.rac4sql.net



-- 
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net



"ricksql@yahoo.com" <u50415039@spawnkill.ip-mobilphone.net> wrote in message
news:l.1062563763.1400665283@host-66-81-69-23.rev.o1.com...
> #temptable (studentID,p/f,examid,examname):
> 1   p
> 2   f    100  bio
> 2   f    101  mTH
> 2   f    102  CHM
> 2   f    103  spts
> 2   f    104  LIT
> 2   f    107  geo
> 2   f    109  phys
> 2   f    110  eng
> 2   f    111  hist
> 3   p
> 4   f    100  bio
> 4   f    102  chm
> 4   f    109  phys
> 4   f    110  eng
>
> #tempResult:
>
> (studentid,p/f,1st,2st,3rd,4th,5th)
> 1  p
> 2  f   bio  math  chm  spts  lit
> 3  p
> 4  f   bio  chm  phys  eng
>
>
> what query turns #temptable to #tempresult?.
> rick
>
>
>
>
> -- 
> Sent  by  ricksql from yahoo in field com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new