Re: Re: cross tab??

Article View: bit.databases.mssql-l

Article #6

Back to bit.databases.mssql-l Previous Next

From: ricksql
Date: Thu, 04 Sep 2003 14:45

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

Technical Details

Message-ID: <r.1062686737.1692291259@[63.127.215.130]>

Path:

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

References: <l.1062655325.1585388183@host-66-81-125-196.rev.o1.com> <uBzUUIrcDHA.2460@TK2MSFTNGP10.phx.gbl>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 107d2f,66939edd6c08ef49
X-Google-Attributes: gid107d2f,public
X-Google-Thread: 106afd,66939edd6c08ef49
X-Google-Attributes: gid106afd,public
X-Google-Thread: 104de1,66939edd6c08ef49
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,66939edd6c08ef49
X-Google-Attributes: gidf6611,public
X-Google-ArrivalTime: 2003-09-04 08:00:23 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: Re: Re: cross tab??
Date: Thu, 04 Sep 2003 14:45:37 GMT
Lines: 47
Message-ID: <r.1062686737.1692291259@[63.127.215.130]>
References: <l.1062655325.1585388183@host-66-81-125-196.rev.o1.com> <uBzUUIrcDHA.2460@TK2MSFTNGP10.phx.gbl>
NNTP-Posting-Host: 0063.00127.0215.0130
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit
X-Mailer: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) - ur
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!feed.news.nacamar.de!news1.ip-mobilphone.net!news2.ip-mobilphone.net!u50415039@spawnkill.ip-mobilphone.net

Reply to Parent Message