Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Kreuztabelle (Access => SQL Server)

144 views
Skip to first unread message

Hans Mock

unread,
Aug 28, 2003, 10:05:32 AM8/28/03
to
Wie kamm man folgenden SQL-String (Access-Kreuztabelle) so
umwandeln, dass diese Abfrage auch beim SQL Server
funktioniert ?

>

TRANSFORM Left(First([Auftrag]),1) & Str(First
([VeranstDatb]-[VeranstDatv])-1) AS Dauer
SELECT Month([VeranstDatv]) AS Monat, Year([VeranstDatv])
AS Jahr, EventUnion.ProjektNr, EventUnion.VerName AS Name,
EventUnion.Auftrag, EventUnion.VeranstDatv,
EventUnion.VeranstDatb
FROM EventUnion
GROUP BY Month([VeranstDatv]), Year([VeranstDatv]),
EventUnion.ProjektNr, EventUnion.VerName,
EventUnion.Auftrag, EventUnion.VeranstDatv,
EventUnion.VeranstDatb
ORDER BY Month([VeranstDatv]), Year([VeranstDatv])
PIVOT DatePart("d",[VeranstDatv]) In
("1","2","3","4","5","6","7","8","9","10","11","12","13","1
4","15","16","17","18","19","20","21","22","23","24","25","
26","27","28","29","30","31");

<

Christa Kurschat

unread,
Aug 28, 2003, 10:25:50 AM8/28/03
to
Hallo Hans,

Hans Mock <hans...@aol.com> schrieb:

schau mal in der OH unter Kreuztabellenberichte nach.

Gruß
Christa
--
Access-FAQ: http://www.donkarl.com
KnowHow.mdb: http://www.freeaccess.de
SQL-Server-FAQ: http://www.berndjungbluth.de
Newbie-Info: http://www.doerbandt.de/Access/Newbie.htm
Suchen in den Newsgroups:
http://groups.google.de/advanced_group_search?hl=de&lr=&ie=UTF-8


Anton Hengg

unread,
Aug 28, 2003, 1:10:05 PM8/28/03
to
Hallo Hans,

schau mal da: http://www.itrain.de/knowhow/sql/tsql/pivot/pivot.asp

Gruss
Anton

"Hans Mock" <hans...@aol.com> schrieb im Newsbeitrag
news:060e01c36d6d$71db5bd0$a001...@phx.gbl...

0 new messages