query??

Thread View: bit.databases.mssql-l

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by ricksql Wed, 03 Sep 2003 04:36

#226

Author: ricksql
Date: Wed, 03 Sep 2003 04:36

36 lines
1961 bytes

#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

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