Hi I Have One Xml File Data How Convert It To Table In Sql

Question

0.00/5 (No votes)

See more:

XML

<?xml version="1.0"?>

-<CalData>

<Serial/>


-<LefCalInfo>

<Uncapped>false</Uncapped>

<NoOfSessionCals>-1</NoOfSessionCals>

<NoOfUsageCals>-1</NoOfUsageCals>

<NoOfNamedCals>20</NoOfNamedCals>

<NoOfClusterNodes>1</NoOfClusterNodes>

<NoOfDocumentCals>80</NoOfDocumentCals>

<NoOfInfrequentNamedCals>0</NoOfInfrequentNamedCals>

<NoOfConcurrentInfrequentNamedCals>0</NoOfConcurrentInfrequentNamedCals>

</LefCalInfo>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\AJAY</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E489C87F258BF2</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\ASHISH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4958393E93E94</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\ASHOK</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E49849EDB363BF</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE1</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4990E1CD2DE3F</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE2</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E499091585E0E7</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE3</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4990C69876543</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\CHANDRA</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4916E67104EE3</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\INDRANI</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E49849F240795D</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\JIGISHA.S</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E493CE6F98D76B</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\KPKADMIN</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498B61BE02469</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\MAHESH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4620C258BF259</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\PIYUSH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498CB1B97530F</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\PRASHANT.G</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4944647042BFE</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\RAHUL</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E489695CD2DE3F</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\RAJ</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E493315EA00C23</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\SEETHALAKSHMI.H</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4976FF839A5BC</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\SHYJU.R</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E49527F6FE1A8C</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\VIMAL.T</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E499085F92C5F9</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\VISHY.C</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4916E3D0F8CB4</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>


-<PerServerCalData>


-<PerServerCalData>

<ServerName>COLOSERV1</ServerName>

<LastUpdated>40E4990EC1E573AC</LastUpdated>

</PerServerCalData>

</PerServerCalData>

<AvailableUsageCals>BFF0000000000000</AvailableUsageCals>

<UsageCalUpdateTimestamp>0000000000000000</UsageCalUpdateTimestamp>


-<PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\ACT\ACT.QVW</DocumentName>

<NoOfNamedCals>5</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE1</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E487AD6468ACF1</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\ACT\ACT_TALLY.QVW</DocumentName>

<NoOfNamedCals>2</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\INDRANI</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E478F0E2833945</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\FMG\FMG.QVW</DocumentName>

<NoOfNamedCals>6</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\CHASE.H</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E486E9E2FC9630</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\GEOFF.W</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E486E9ECF1357A</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\SANDEEP.K</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E46E32612F684C</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\SEBASTIAN.M</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E48B2F76E5D4C4</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\VAIBHAV.O</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4988B36543210</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\FMG\FMG_AUTOMATION.QVW</DocumentName>

<NoOfNamedCals>1</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\VAIBHAV.O</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E48110AC5F92C6</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\FUND_MIS\IVFA_FUND.QVW</DocumentName>

<NoOfNamedCals>3</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\AMITH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>FE37E43C8800759C</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\DHARMESH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>FE37E43C8800759C</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\SUTHESH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>FE37E43C8800759C</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>false</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\FUND_MIS\MIS\IVFA_MIS.QVW</DocumentName>

<NoOfNamedCals>1</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\DHARMESH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>FE37E43C8800759C</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>false</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\HICARE\HICARE.QVW</DocumentName>

<NoOfNamedCals>10</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE3</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4978BA32D21C1</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\NAITIK</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E49890A93E93E9</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\RAHUL.P</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498923F3DD1BB</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\IFAPL\IFAPL_WIP.QVW</DocumentName>

<NoOfNamedCals>5</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE3</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E497889CEB2408</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\FINCARE1</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4988D38091A2B</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\FINCARE3</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4958CD6480F2C</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\SUTHESH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4990B966054F4</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\INLOGISTICS\IN_LOGISTICS.QVW</DocumentName>

<NoOfNamedCals>3</NoOfNamedCals>

<NamedCalsAllocated/>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\INLOGISTICS\IN_LOG_OP_DASHBOARD.QVW</DocumentName>

<NoOfNamedCals>3</NoOfNamedCals>

<NamedCalsAllocated/>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\INTERNAL\FUND\IVFA_FUND.QVW</DocumentName>

<NoOfNamedCals>1</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\SUTHESH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>FE37E43C8800759C</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>false</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\INTERNAL\MIS\IVFA_MIS.QVW</DocumentName>

<NoOfNamedCals>1</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\DHARMESH</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>FE37E43C8800759C</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>false</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\KEYA\KEYA SALES ANALYSIS.QVW</DocumentName>

<NoOfNamedCals>16</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\ABHIJIT.B</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4990D8C3B2A19</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\AYSHA.AG</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4982CD1111111</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\KIRAN.P</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498B0121C10B0</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\MUTHU.K</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498F068ACF136</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\RAHUL.SAINI</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498CD91BAF98E</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\RAJU.D</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E49908D950C840</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\RATAN.P</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498D1BDD1BAFA</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\ROOPESH.H</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498CCC2BFE7BA</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\SANJEEV.N</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498B1B89ABCDF</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\SHAILENDRA.S</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498CE4A6DFC35</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\KEYA\KEYA WIP.QVW</DocumentName>

<NoOfNamedCals>2</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\AYSHA.AG</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4982BAADB363C</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE1</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E487AD55FF3DD2</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\MERU\MERU MIS AS IS.QVW</DocumentName>

<NoOfNamedCals>2</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\VIMAL.T</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E48F73A1C10B00</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\MERU\MERU MIS THRU AUTOMATION.QVW</DocumentName>

<NoOfNamedCals>2</NoOfNamedCals>

<NamedCalsAllocated/>

<AllowDynamicAllocation>false</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\MERU\MERU WIP.QVW</DocumentName>

<NoOfNamedCals>2</NoOfNamedCals>

<NamedCalsAllocated/>

<AllowDynamicAllocation>false</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\RDC\RDC.QVW</DocumentName>

<NoOfNamedCals>3</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE3</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E487A9871C71C7</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\UMESH.G</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E49791E5A43821</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>MANISH.M</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>FE37E43C8800759C</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\ROBO\ROBO.QVW</DocumentName>

<NoOfNamedCals>4</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE1</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E48A47EAAAAAAB</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\CFOBRIDGE3</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4878DB60B60B6</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\MURTHY.V</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E496E5C3518A6E</LastUsed>

</CalAllocEntry>


-<CalAllocEntry>

<Name>COLOSERV1\SONICA.G</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4952C6D21C10B</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\ROBO\ROBO_SALES_REPORT.QVW</DocumentName>

<NoOfNamedCals>2</NoOfNamedCals>

<NamedCalsAllocated/>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\ROBO\ROBO_SALES_REPORT\ROBO_SALES_ANALYSIS.QVW</DocumentName>

<NoOfNamedCals>2</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\SONICA.G</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E498505B66C77E</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\UEM\UEM_APPLICATION.QVW</DocumentName>

<NoOfNamedCals>1</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\RAJEEV.M</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>40E4878D2E450672</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>


-<PerDocumentCalData>

<DocumentName>IVFA\VKL\VKL_WIP.QVW</DocumentName>

<NoOfNamedCals>2</NoOfNamedCals>


-<NamedCalsAllocated>


-<CalAllocEntry>

<Name>COLOSERV1\KRANTHI.B</Name>

<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>

<LastUsed>FE37E43C8800759C</LastUsed>

</CalAllocEntry>

</NamedCalsAllocated>

<AllowDynamicAllocation>true</AllowDynamicAllocation>

<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>

<EmbeddedSerial/>

<NamedCalsInUse/>

</PerDocumentCalData>

</PerDocumentCalData>

<NamedCalsInUse/>

<SessionCalsInUse/>

<InfrequentNamedCalsInUse/>

<InfrequentSessionCalsInUse/>

<InfrequentNamedCalsAllocated/>

<SessionsOnUsageCals>0</SessionsOnUsageCals>

</CalData>

Posted 24-Jul-15 0:28am

Tryingtobeageek

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-07-24T01:09:00

Not sure if I understood the question correctly but if you want to add the data from CalAllocEntry elements into a table using T-SQL then perhaps something like

SQL

DECLARE @xmldoc xml
SET @xmldoc = '
<caldata>
   <serial />
   <lefcalinfo>
      <uncapped>false</uncapped>
      <noofsessioncals>-1</noofsessioncals>
      <noofusagecals>-1</noofusagecals>
      <noofnamedcals>20</noofnamedcals>
      <noofclusternodes>1</noofclusternodes>
      <noofdocumentcals>80</noofdocumentcals>
      <noofinfrequentnamedcals>0</noofinfrequentnamedcals>
      <noofconcurrentinfrequentnamedcals>0</noofconcurrentinfrequentnamedcals>
   </lefcalinfo>
   <namedcalsallocated>
      <calallocentry>
         <name>COLOSERV1\AJAY</name>
         <tobedeleted>FE37E43C8800759C</tobedeleted>
         <lastused>40E489C87F258BF2</lastused>
      </calallocentry>
      <calallocentry>
         <name>COLOSERV1\ASHISH</name>
         <tobedeleted>FE37E43C8800759C</tobedeleted>
         <lastused>40E4958393E93E94</lastused>
      </calallocentry>
      <calallocentry>
         <name>COLOSERV1\ASHOK</name>
         <tobedeleted>FE37E43C8800759C</tobedeleted>
         <lastused>40E49849EDB363BF</lastused>
      </calallocentry>
   </namedcalsallocated>
</caldata>'


SELECT a.col1.value('(Name)[1]', 'nvarchar(100)') AS Name,
       a.col1.value('(ToBeDeleted)[1]', 'nvarchar(100)') AS ToBeDeleted,
	   a.col1.value('(LastUsed)[1]', 'nvarchar(100)') AS LastUsed
INTO #SomeTable
FROM @xmldoc.nodes('/CalData/NamedCalsAllocated/CalAllocEntry') a(col1)

SELECT * FROM #SomeTable

The result would be

Name             ToBeDeleted	   LastUsed
--------------   ----------------  -----------------
COLOSERV1\AJAY   FE37E43C8800759C  40E489C87F258BF2
COLOSERV1\ASHISH FE37E43C8800759C  40E4958393E93E94
COLOSERV1\ASHOK  FE37E43C8800759C  40E49849EDB363BF

Aravindba · Answer 2 · 2015-07-24T00:49:00

Solution 1

Hi

which tag need to create table in sql ?

check this link
http://vb.net-informations.com/xml/open-xml-vb.net.htm[^]

In Above link "Product" is one of the tag,using for loop u can read its value.

XML File Parsing in VB.NET[^]

Regards
Araindb

Posted 24-Jul-15 0:49am

Aravindba

Updated 24-Jul-15 0:51am

v2

_Asif_ · Answer 3 · 2015-07-24T00:50:00

Solution 2

Well your question is too generic, similarly your xml is also complex and does not seem to be fit one single Table. But we can guide you to have an import mechanism. Check this Import xml into sql server[^] link

Posted 24-Jul-15 0:50am

_Asif_