Insert ... Select ???

Article View: dk.edb.database

Article #15230

#15230

From: stk
Date: Fri, 15 Jun 2001 10:09

28 lines
1548 bytes

Jeg vil gerne ins�tte data fra to tabeller (T1 og T2) i en enkelt
tabel(T3) via en Stored Procedure:
INSERT INTO T3(UserID, UserName, Email)
SELECT UserID FROM T1 WHERE GUID=xxx
SELECT FeltV�rdi FROM T2 WHERE GUID=xxx AND FeltNavn=UserName
SELECT FeltV�rdi FROM T2 WHERE GUID=xxx AND FeltNavn=Email

T1:
GUID   UserID
xxx     BGATES

T2:
GUID   FeltNavn     FeltV�rdi
xxx     UserName    Bill Gates
xxx     Email          b.gates@whatever

T3:
UserID    UserName    Email
BGATES  Bill Gates     b.gates@whatever

Jeg kan ikke helt gennemskue syntaxen for s�dan en insert ... select
ting.
Nogle ideer?

-- 
Leveret af:
http://www.kandu.dk/
"Vejen til en hurtig l�sning"

Technical Details

Message-ID: <_8lW6.1548$hi6.175851@news000.worldonline.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.225.51.30!sunsite.dk!newsrouter.euroconnect.net!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,72179d3b6cccc930,start
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-15 03:09:01 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.225.51.30!sunsite.dk!newsrouter.euroconnect.net!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail
From: "stk" <stk.news@kandu.dk>
Newsgroups: dk.edb.database
Subject: Insert ... Select ???
Lines: 29
Organization: www.kandu.dk supporting usenet (1 537)
Message-ID: <_8lW6.1548$hi6.175851@news000.worldonline.dk>
Date: Fri, 15 Jun 2001 10:09:44 GMT
NNTP-Posting-Host: 213.237.17.223
X-Complaints-To: news-abuse@wol.dk
X-Trace: news000.worldonline.dk 992599738 213.237.17.223 (Fri, 15 Jun 2001 12:08:58 MET DST)
NNTP-Posting-Date: Fri, 15 Jun 2001 12:08:58 MET DST