Click here to Skip to main content
15,746,420 members
Home / Discussions / Database
   

Database

 
GeneralRe: Create a new Primary Key on survey table Pin
learning_new3-Mar-20 4:28
learning_new3-Mar-20 4:28 
QuestionIndexing question Pin
Super Lloyd5-Feb-20 13:35
Super Lloyd5-Feb-20 13:35 
AnswerRe: Indexing question Pin
Eddy Vluggen5-Feb-20 15:09
professionalEddy Vluggen5-Feb-20 15:09 
GeneralRe: Indexing question Pin
Super Lloyd5-Feb-20 17:38
Super Lloyd5-Feb-20 17:38 
GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 2:50
professionalEddy Vluggen6-Feb-20 2:50 
AnswerRe: Indexing question Pin
Jörgen Andersson5-Feb-20 22:28
professionalJörgen Andersson5-Feb-20 22:28 
AnswerRe: Indexing question Pin
Richard Deeming6-Feb-20 0:17
mveRichard Deeming6-Feb-20 0:17 
Questionintegrity constraint Pin
Tara112-Feb-20 6:23
Tara112-Feb-20 6:23 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 8:47
mentorWendelius2-Feb-20 8:47 
GeneralRe: integrity constraint Pin
Tara112-Feb-20 9:07
Tara112-Feb-20 9:07 
GeneralRe: integrity constraint Pin
markkuk2-Feb-20 23:48
markkuk2-Feb-20 23:48 
Questiontransaction recovery Pin
Tara112-Feb-20 5:46
Tara112-Feb-20 5:46 
AnswerRe: transaction recovery Pin
Eddy Vluggen3-Feb-20 3:00
professionalEddy Vluggen3-Feb-20 3:00 
QuestionCopy structure of all the tables of one database to another server Pin
Member 1473192331-Jan-20 4:58
Member 1473192331-Jan-20 4:58 
AnswerRe: Copy structure of all the tables of one database to another server Pin
phil.o31-Jan-20 5:12
professionalphil.o31-Jan-20 5:12 
AnswerRe: Copy structure of all the tables of one database to another server Pin
Eddy Vluggen3-Feb-20 3:01
professionalEddy Vluggen3-Feb-20 3:01 
Questionintegrity constraint Pin
Tara1129-Jan-20 10:36
Tara1129-Jan-20 10:36 
AnswerRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 10:56
professionalMycroft Holmes29-Jan-20 10:56 
GeneralRe: integrity constraint Pin
Tara1129-Jan-20 11:05
Tara1129-Jan-20 11:05 
GeneralRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 11:21
professionalMycroft Holmes29-Jan-20 11:21 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 9:01
mentorWendelius2-Feb-20 9:01 
QuestionOracle SQL query to MS-SQL Pin
Member 951930620-Jan-20 22:37
Member 951930620-Jan-20 22:37 
AnswerRe: Oracle SQL query to MS-SQL Pin
Richard Deeming21-Jan-20 1:43
mveRichard Deeming21-Jan-20 1:43 
The tool doesn't seem to have done anything! Laugh | :laugh:

At a guess, you're looking for something like:
SQL
UPDATE
    c
SET
    stat = l.status, 
    statusdto = CASE SUBSTRING(l.statushaenstart, 7, 2)
        WHEN '00' THEN NULL 
        ELSE CONVERT(datetime, SUBSTRING(l.statushaenstart, 1, 8)) 
    END,
    pnrgaeld = l.pnrgaeld,
    koen = l.koen, 
    fornvnmrk = a.fornvn_mrk, 
    mellemnvnmrk = a.melnvn_mrk,
    efternvnmrk = a.efternvn_mrk,
    nvndto = CASE SUBSTRING(a.nvnhaenstart, 7, 2)
        WHEN '00' THEN NULL 
        ELSE CONVERT(datetime, SUBSTRING(a.nvnhaenstart, 1, 8)) 
    END, 
    fornvn_solo = UPPER(a.fornvn),
    fornvn = SUBSTRING(CASE
        WHEN a.melnvn Is Null THEN UPPER(a.fornvn)
        ELSE UPPER(a.fornvn) + ' ' + UPPER(a.melnvn)
    END, 1, 50), 
    mellemnvn = UPPER(a.melnvn),
    efternvn = UPPER(a.efternvn),
    adr_fornvn = UPPER(LTRIM(SUBSTRING(a.adrnvn, CHARINDEX(',', a.adrnvn) + 1, LEN(a.adrnvn)))),
    adr_efternvn = UPPER(SUBSTRING(a.adrnvn, 1, CHARINDEX(',', a.adrnvn) - 1)),
    stilling = UPPER(l.stilling),
    z_stilling = l.stilling,
    z_fornvn = SUBSTRING(CASE
        WHEN a.melnvn Is Null THEN a.fornvn
        ELSE a.fornvn + ' ' + a.melnvn
    END, 1, 50),
    z_mellemnvn = a.melnvn,
    z_efternvn = a.efternvn,
    z_adr_fornvn = LTRIM(SUBSTRING(a.adrnvn, CHARINDEX(',', a.adrnvn) + 1, LEN(a.adrnvn))), 
    z_adr_efternvn = SUBSTRING(a.adrnvn, 1, CHARINDEX(',', a.adrnvn) - 1), 
    z_fornvn_solo = a.fornvn,
    haenstart_umrk_navne = a.haenstart_umrk_navne,
    stillingdto = Null,
    mynkod_ctnavn = Null,
    myntxt_ctnavn = Null,
    indrap = Null,
    adrnvndto = Null,
    soegnvn = Null,
    soegnvndto = Null
FROM
    folk.individ As c
    INNER JOIN folk.lperson2010 As l ON l.pnr = c.pnr
    INNER JOIN folk.laktnvnopl2010 a ON a.pnr = c.pnr
WHERE
    l.lseq BETWEEN 1 AND 6000
;




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Oracle SQL query to MS-SQL Pin
Member 951930628-Jan-20 22:44
Member 951930628-Jan-20 22:44 
GeneralRe: Oracle SQL query to MS-SQL Pin
Mycroft Holmes29-Jan-20 10:59
professionalMycroft Holmes29-Jan-20 10:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.