Click here to Skip to main content
15,880,405 members
Home / Discussions / Database
   

Database

 
AnswerRe: What is database SQL query to display the name of the table only in to datagrid? Pin
vvashishta10-May-12 4:17
vvashishta10-May-12 4:17 
GeneralRe: What is database SQL query to display the name of the table only in to datagrid? Pin
Eddy Vluggen10-May-12 7:05
professionalEddy Vluggen10-May-12 7:05 
Questionchoosing a database Pin
davood_b8-May-12 1:19
davood_b8-May-12 1:19 
AnswerRe: choosing a database Pin
PIEBALDconsult8-May-12 3:16
mvePIEBALDconsult8-May-12 3:16 
QuestionRe: choosing a database Pin
Eddy Vluggen8-May-12 5:05
professionalEddy Vluggen8-May-12 5:05 
GeneralRe: choosing a database Pin
PIEBALDconsult8-May-12 18:42
mvePIEBALDconsult8-May-12 18:42 
AnswerRe: choosing a database Pin
Eddy Vluggen8-May-12 5:08
professionalEddy Vluggen8-May-12 5:08 
Questionusing xquery to populate a table variable in sql Pin
swjam6-May-12 4:34
swjam6-May-12 4:34 
XML
Hi, Just would like to ask for help for the xquery that I need to use for the xml string below to populate my table with the following dimension.  This means that for each manager, I can have more than 1 row (depending on the number of staff) as I have flattened the table to eliminate joins on multiple table vars.  Sorry, I just couldn't get my xquery right.
Finally, if I have my xsd, how do I validate an xml input such as above with sql?
Many thanks.

Manager      Name      Type      Staff


declare @myOrg xml
set @myOrg = '<?xml version="1.0" encoding="utf-8"?>
<Department>
  <Subdivision>
    <Managers>
      <Manager>
        <Name>Martin</Name>
        <Type>Full Time</Type>
        <Purpose>Subdivision 1 Shadow</Purpose>
        <Description>Project Management, Operations</Description>
        <FullName>Martin Fuller</FullName>
        <StaffList>
          <Staff>H1 Level 4, 345Y</Staff>
          <Staff>H1 Level 4, DS23</Staff>
        </StaffList>
      </Manager>
      <Manager>
        <Name></Name>
        <Type></Type>
        <Purpose></Purpose>
        <Description></Description>
        <FullName></FullName>
        <StaffList>
          <Staff></Staff>
        </StaffList>
      </Manager>
    </Managers>
  </Subdivision>
</Department>'

----------------------------------------------------------
Lorem ipsum dolor sit amet.

QuestionRead LFD(log ) file SQLserver 2008 Pin
jojoba20114-May-12 17:38
jojoba20114-May-12 17:38 
AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen4-May-12 23:11
professionalEddy Vluggen4-May-12 23:11 
QuestionRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba20114-May-12 23:19
jojoba20114-May-12 23:19 
AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen4-May-12 23:31
professionalEddy Vluggen4-May-12 23:31 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba20115-May-12 20:31
jojoba20115-May-12 20:31 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
Mycroft Holmes5-May-12 23:00
professionalMycroft Holmes5-May-12 23:00 
JokeRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen6-May-12 6:08
professionalEddy Vluggen6-May-12 6:08 
AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen6-May-12 0:37
professionalEddy Vluggen6-May-12 0:37 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba20116-May-12 23:30
jojoba20116-May-12 23:30 
AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen7-May-12 0:30
professionalEddy Vluggen7-May-12 0:30 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba20117-May-12 17:37
jojoba20117-May-12 17:37 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
JohnPayton7-May-12 18:10
JohnPayton7-May-12 18:10 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen8-May-12 0:17
professionalEddy Vluggen8-May-12 0:17 
QuestionRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba20119-May-12 17:52
jojoba20119-May-12 17:52 
AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen10-May-12 0:07
professionalEddy Vluggen10-May-12 0:07 
QuestionRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba201111-May-12 17:28
jojoba201111-May-12 17:28 
AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen12-May-12 0:45
professionalEddy Vluggen12-May-12 0:45 

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.