cross tab?

thought my question was misinterpreted.

actual table can be smaller or larger. but,
within a procedure need to turn a created #temptable
similar to(examid is in asc order):
(id, p/f, examid, examname)
1 f xxxx xxxxx
1 f xxxx xxxxx
1 f xxxx xxxxx
2 p
3 p
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx

(note, id = 4 has 7 failed exams).

to a table with up to five columns of failed
examnames:

1 f xxxxx xxxxx xxxxx
2 p
2 p
4 f xxxxx xxxxx xxxxx xxxxx xxxxx

can get rid of exameid if helps.

--
Sent by ricksql from yahoo subpart from com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/newso what you need is a crosstab table with a 5 recors limit only ?

Jens Smeyer.|||Dear Jens S|_meyer,

> so what you need is a crosstab table with a 5 recors limit only ?
> Jens S|_meyer.

yes.

within a procedure need to turn a created #temptable
similar to:
(id, p/f, examid, examname)
1 f xxxx xxxxx
1 f xxxx xxxxx
1 f xxxx xxxxx
2 p
3 p
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx
4 f xxxx xxxxx

(note, id = 4 has 7 failed exams).

to a table with up to five columns of failed
examnames:

1 f xxxxx xxxxx xxxxx
2 p
2 p
4 f xxxxx xxxxx xxxxx xxxxx xxxxx

can get rid of exameid if helps.

--
Spam protected message from:
Sent by ricksql from yahoo subpart from com
Posted via http://www.usenet-replayer.com/cgi/content/new