Thread View: bit.databases.mssql-l
3 messages
3 total messages
Started by ricksql
Thu, 04 Sep 2003 06:02
cross tab??
Author: ricksql
Date: Thu, 04 Sep 2003 06:02
Date: Thu, 04 Sep 2003 06:02
39 lines
2172 bytes
2172 bytes
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/new
Re: cross tab??
Author: Jens Smeyer
Date: Thu, 04 Sep 2003 07:05
Date: Thu, 04 Sep 2003 07:05
3 lines
1257 bytes
1257 bytes
so what you need is a crosstab table with a 5 recors limit only ? Jens S��meyer.
Re: Re: cross tab??
Author: ricksql
Date: Thu, 04 Sep 2003 14:45
Date: Thu, 04 Sep 2003 14:45
48 lines
2191 bytes
2191 bytes
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
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads