cross tab??

Article View: bit.databases.mssql-l

Article #3

Back to bit.databases.mssql-l Previous Next

From: ricksql
Date: Thu, 04 Sep 2003 06:02

39 lines
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

Technical Details

Message-ID: <l.1062655325.1585388183@host-66-81-125-196.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: f6611,66939edd6c08ef49,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 106afd,66939edd6c08ef49,start
X-Google-Attributes: gid106afd,public
X-Google-Thread: 104de1,66939edd6c08ef49,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: 107d2f,66939edd6c08ef49,start
X-Google-Attributes: gid107d2f,public
X-Google-ArrivalTime: 2003-09-03 23:30:26 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.de.sqlserver,microsoft.public.sqlserver
Subject: cross tab??
Date: Thu, 04 Sep 2003 06:02:05 GMT
Lines: 40
Message-ID: <l.1062655325.1585388183@host-66-81-125-196.rev.o1.com>
NNTP-Posting-Host: 66.81.125.196
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
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