Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amankazi@gmail.com
Starting Member
1 Post |
 Posted - 2009-04-24 : 00:55:05
|
| I want the output to be in the following manner using the "StoredProcedure-sp_xml_preparedocument", And please expalin how it work as I am new to XML bulk insertionActivity RoleID-----------------------Producer 7Producer 8Director 8Dispatch 9Declare @Activities XMLSET @Activities = N'<?xml version="1.0" encoding="utf-16"?><ArrayOfCDTOActivityInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><cDTOActivityInfo> <ActivityID>0</ActivityID> <ActivityName>Producer</ActivityName> <DTORolesCollection> <cDTORoles> <RoleID>7</RoleID> <IsActive>false</IsActive> </cDTORoles> <cDTORoles> <RoleID>8</RoleID> <IsActive>false</IsActive> </cDTORoles> </DTORolesCollection></cDTOActivityInfo> <cDTOActivityInfo> <ActivityID>0</ActivityID> <ActivityName>Director</ActivityName> <DTORolesCollection> <cDTORoles> <RoleID>8</RoleID> <IsActive>false</IsActive> </cDTORoles> </DTORolesCollection> </cDTOActivityInfo> <cDTOActivityInfo> <ActivityID>0</ActivityID> <ActivityName>Dispath</ActivityName> <DTORolesCollection> <cDTORoles> <RoleID>9</RoleID> <IsActive>false</IsActive> </cDTORoles> <cDTORoles> <RoleID>9</RoleID> <IsActive>false</IsActive> </cDTORoles> </DTORolesCollection></cDTOActivityInfo></ArrayOfCDTOActivityInfo>' |
|
|
|
|
|
Buik insertion