Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*<Spisak_RM>
- <Radno_Mesto sifRM="111">
- <Naziv_RM>Projektant</Naziv_RM>
- <Angazovanja_RM>
- <Angazovanje>
- <Sifra_Radnika>1</Sifra_Radnika>
- <ImeRadnika>Marko</ImeRadnika>
- <Vreme_Angazovanja>
- <Od>01.08.2007</Od>
- <Do>05.02.2013</Do>
- </Vreme_Angazovanja>
- </Angazovanje>
- </Angazovanja_RM>
- </Radno_Mesto>
- . . .*/
- /*
- . . .
- <Radno_Mesto sifRM="666">
- <Naziv_RM>Administrator</Naziv_RM>
- <Angazovanja_RM>
- <Angazovanje>
- . . .
- </Angazovanje>
- <Angazovanje>
- . . .
- <Vreme_Angazovanja>
- . . .
- </Vreme_Angazovanja>
- </Angazovanje>
- . . .
- </Radno_Mesto>
- . . .
- </Spisak_RM>
- */
- SELECT
- rm.SIFRARM as "@sifRM",
- rm.NAZIVRM as "Naziv_RM",
- (
- SELECT
- a.SIFRAZAP as "Sifra_Radnika",
- r.IME as "ImeRadnika",
- convert(varchar, a.DATOD, 104) as "Vreme_Angazovanja/Od",
- convert(varchar, a.DATDO, 104) as "Vreme_Angazovanja/Do"
- FROM ANGAZOVANJE a JOIN RADNIK r on a.SIFRAZAP=r.SIFRAZAP
- WHERE a.SIFRARM = rm.SIFRARM
- FOR XML PATH('Angazovanje'),
- TYPE
- ) Angazovanja_RM
- FROM RADNO_MESTO rm
- FOR XML PATH('Radno_Mesto'),
- ROOT('Spisak_RM')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement