query??

Article View: bit.databases.mssql-l

Article #226

Back to bit.databases.mssql-l Previous Next

#226

From: 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

Technical Details

Message-ID: <l.1062563763.1400665283@host-66-81-69-23.rev.o1.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.nacamar.de!news1.ip-mobilphone.net!news2.ip-mobilphone.net!u50415039@spawnkill.ip-mobilphone.net

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11301e,491a6121cd5fc1c6,start
X-Google-Attributes: gid11301e,public
X-Google-Thread: f6611,491a6121cd5fc1c6,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 107d2f,491a6121cd5fc1c6,start
X-Google-Attributes: gid107d2f,public
X-Google-Thread: 104de1,491a6121cd5fc1c6,start
X-Google-Attributes: gid104de1,public
X-Google-ArrivalTime: 2003-09-02 22:00:30 PST
From: u50415039@spawnkill.ip-mobilphone.net  (ricksql@yahoo.com)
Sender: u50415039@spawnkill.ip-mobilphone.net
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver,microsoft.public.sqlserver,microsoft.public.sqlserver.programming
Subject: query??
Date: Wed, 03 Sep 2003 04:36:02 GMT
Lines: 37
Message-ID: <l.1062563763.1400665283@host-66-81-69-23.rev.o1.com>
NNTP-Posting-Host: 66.81.69.23
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Mailer: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 - ur
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.nacamar.de!news1.ip-mobilphone.net!news2.ip-mobilphone.net!u50415039@spawnkill.ip-mobilphone.net