Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #2045
| Newsgroups | comp.databases.ms-sqlserver |
|---|---|
| Date | 2020-06-10 15:30 -0700 |
| References | (1 earlier) <XnsABD8DEF547D6EYazorman@127.0.0.1> <25356606-299b-4623-809d-0d6eb9af0906o@googlegroups.com> <XnsABD8F11BF16BFYazorman@127.0.0.1> <4b1c3504-2511-4c3c-a5fb-b880e39caeb6o@googlegroups.com> <XnsABD928EDA5F3Yazorman@127.0.0.1> |
| Message-ID | <07f4ed04-6ddf-42e8-afac-655b93b690e3o@googlegroups.com> (permalink) |
| Subject | Re: Unable to query xml data in sql server |
| From | chris H <chris.sjpd@gmail.com> |
On Wednesday, June 10, 2020 at 3:15:07 PM UTC-7, Erland Sommarskog wrote:
> chris H (chris.sjpd@gmail.com) writes:
> > That is a complete xml file. When I doubleclick to open it, it does not have root tag.
> >
>
> I would say it's not an XML file then. An XML file has exactly a single root tag. SQL Server supports repeated root tags, but there are no root tags at all here.
>
> I get this error from sp_xml_preparedocument:
>
> Msg 6602, Level 16, State 2, Procedure sp_xml_preparedocument, Line 1 [Batch Start Line 0]
> The error description is 'Only one top level element is allowed in an XML document.'.
>
>
> DECLARE @x xml =
> ' <AccidentReportNumber-AllPages>2020-200320523</AccidentReportNumber-AllPages>
> <AddressFullText>1493 CRESTHAVEN LN,SAN JOSE, CA, 95118</AddressFullText>
> <InjuredWas_driver>1</InjuredWas_driver>
> <PedestrianActionA-AllPages>1</PedestrianActionA-AllPages>
> <MotorVehicleInvolvedWithC-AllPages>1</MotorVehicleInvolvedWithC-AllPages>
> <CollisionOccurredDate-AllPages>02-01-2020</CollisionOccurredDate-AllPages>
> <Time-AllPages>1547</Time-AllPages>'
>
> DECLARE @hDoc int
> EXEC sp_xml_preparedocument @hDoc OUTPUT, @x
>
>
> SELECT *
> FROM OPENXML(@hDoc, '/', 1)
> WITH
> (
> [AccidentReportNumber-AllPages] varchar(20),
> AddressFullText varchar(100) '/trafficunit/driver',
> "InjuredWas_driver" int '/involvedPeople',
> [PedestrianActionA-AllPages] int,
> [MotorVehicleInvolvedWithC-AllPages] int,
> [CollisionOccurredDate-AllPages] date,
> [Time-AllPages] int
> )
>
> EXEC sp_xml_removedocument @hDoc OUTPUT
This is all I have to work with :-( The xml file is coming from an application which combines some columns from db & others from the xml form. I have spent a lot of time to get it work because we only need data in a few columns
<agency xmlns="" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:ev="http://www.w3.org/2001/xml-events" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope" xmlns:fjs1="http://www.versaterm.com/rms/ns/RMS_7.2" xmlns:fjs2="http://www.versaterm.com/rms/types/RMS_7.2" formLock="off" project_name="mva_california" form_version="065" form_path="site/version/" formname="vtm_california_mva_v1">
<PageNum />
<Pages />
<TrafficUnit>
<TrafficUnit_Number>1</TrafficUnit_Number>
<Driver>
<BlankOption />
<TrafficUnit_Number />
<ID_Num>442240070</ID_Num>
<RoleTrans>Drv(ACC)</RoleTrans>
<RoleNumber>1</RoleNumber>
<AddressFullText>1554 GLENCREST CT,SAN JOSE, CA, 95118</AddressFullText>
<AddressStreetText>1554 GLENCREST CT</AddressStreetText>
<AddressCityStateZip>SAN JOSE, CA, 95118</AddressCityStateZip>
<City>SAN JOSE</City>
<State>CA</State>
<Zip>95118</Zip>
<StateOfIssue>CA</StateOfIssue>
<LicenseClass>01</LicenseClass>
<Sex>F</Sex>
<Hair>BRO</Hair>
<Eyes>BRO</Eyes>
<Height>5'06</Height>
<Weight>140</Weight>
<Race>W</Race>
<DateOfBirth>09-20-1985</DateOfBirth>
<BirthDateYear>1985</BirthDateYear>
<BirthDateMonth>09</BirthDateMonth>
<BirthDateDay>20</BirthDateDay>
<Age>34</Age>
<ChargeDescriptionText />
</Driver>
<Vehicle>
<BlankOption />
<ID_Num>211222</ID_Num>
<RoleTrans>Involved (ACCIDENTS&STR CHKS)</RoleTrans>
<RoleNumber>1</RoleNumber>
<ModelYear>2020</ModelYear>
<Make>TOYT</Make>
<Model>SNA</Model>
<Style>4H</Style>
<Colour>WHI/</Colour>
<StateOfIssue>CA</StateOfIssue>
<AddressFullText />
<CityState />
<Zip />
<VehicleType>1</VehicleType>
<NumberOfOccupants />
<InsuranceName>AAA</InsuranceName>
<InsuranceExpiryDate />
</Vehicle>
<MovementProcedingCollisionB />
<MovementProcedingCollisionC />
<MovementProcedingCollisionA />
<MovementProcedingCollisionE>1</MovementProcedingCollisionE>
<VehicleOwner>
<BlankOption />
<ID_Num>442240070</ID_Num>
<RoleTrans>Drv(ACC)</RoleTrans>
<RoleNumber>1</RoleNumber>
<Seat_position />
<AddressFullText>1554 GLENCREST CT</AddressFullText>
<CityState>SAN JOSE, CA</CityState>
<Zip>95118</Zip>
<ProvStateOfIssue>CA</ProvStateOfIssue>
<Age>34</Age>
<Sex>F</Sex>
<BirthDateYear>1985</BirthDateYear>
<BirthDateMonth>09</BirthDateMonth>
<BirthDateDay>20</BirthDateDay>
</VehicleOwner>
<NameSameAsDriver />
<AddrSameAsDriver />
<TrafficUnitDriverOtherCheck />
<TrafficUnitDriverBikeCheck />
<TrafficUnitDriverParkedCheck />
<TrafficUnitPedestrianCheck />
<TrafficUnitDriverCheck>1</TrafficUnitDriverCheck>
<DispositionVehicleByOfficer />
<DispositionVehicleByDriver>1</DispositionVehicleByDriver>
<DispositionVehicleByOther />
<PriorMechanicalDefectsNone />
<PriorMechanicalDefectsNarr />
<DescribeVehDamageUnk />
<DescribeVehDamageNone />
<DescribeVehDamageMinor />
<DescribeVehDamageMod />
<DescribeVehDamageMajor>1</DescribeVehDamageMajor>
<DescribeVehDamageRollOver />
<Damage_14 />
<Damage_13 />
<Damage_11>1</Damage_11>
<Damage_9>1</Damage_9>
<Damage_7 />
<Damage_4 />
<Damage_3 />
<Damage_2 />
<Damage_12 />
<Damage_1 />
<Damage_10>1</Damage_10>
<Damage_8 />
<Damage_6 />
<Damage_5 />
<VehicleType1 />
<VehicleType2 />
<SpecialInformationA />
<SpecialInformationB />
<SpecialInformationC />
<SpecialInformationE />
<SpecialInformationD />
<SpecialInformationF />
<SpecialInformationG />
<SpecialInformationI />
<SpecialInformationH />
<SpecialInformationJ />
<SpecialInformationK />
<SpecialInformationL />
<SpecialInformationM />
<SpecialInformationN />
<SpecialInformationO />
<OtherAssociatedFactorsC />
<OtherAssociatedFactorsB />
<OtherAssociatedFactorsA />
<OtherAssociatedFactorsE />
<OtherAssociatedFactorsF />
<OtherAssociatedFactorsG />
<OtherAssociatedFactorsH />
<OtherAssociatedFactorsI />
<OtherAssociatedFactorsJ />
<OtherAssociatedFactorsK />
<OtherAssociatedFactorsL />
<OtherAssociatedFactorsM />
<OtherAssociatedFactorsN />
<OtherAssociatedFactorsO />
<MovementProcedingCollisionD />
<MovementProcedingCollisionF />
<MovementProcedingCollisionG />
<MovementProcedingCollisionH />
<MovementProcedingCollisionI />
<MovementProcedingCollisionJ />
<MovementProcedingCollisionK />
<MovementProcedingCollisionL />
<MovementProcedingCollisionM />
<MovementProcedingCollisionN />
<MovementProcedingCollisionO />
<MovementProcedingCollisionP />
<MovementProcedingCollisionQ />
<MovementProcedingCollisionR />
<SobrietyDrugPhysicalA>1</SobrietyDrugPhysicalA>
<SobrietyDrugPhysicalC />
<SobrietyDrugPhysicalB />
<SobrietyDrugPhysicalE />
<SobrietyDrugPhysicalD />
<SobrietyDrugPhysicalF />
<SobrietyDrugPhysicalG />
<SobrietyDrugPhysicalH />
<SobrietyDrugPhysicalI />
<OnDutyEMV />
<DriverAirBag-Box-16>M</DriverAirBag-Box-16>
<DriverSafetyEquipmentUsed-Box-18>G</DriverSafetyEquipmentUsed-Box-18>
<Direction-Box-5>SE</Direction-Box-5>
<OnStreetOrHighway>BRANHAM LN</OnStreetOrHighway>
<SpeedLimit>35</SpeedLimit>
<DispositionText />
<OtherAssociatedFactorsAText />
<OtherAssociatedFactorsACitedYesNO />
<CAL_T />
<MC_MX />
<CA />
<DOT />
<TCP_PSC />
</TrafficUnit>
<TrafficUnit>
<TrafficUnit_Number>2</TrafficUnit_Number>
<Driver>
<BlankOption />
<TrafficUnit_Number />
<ID_Num>442240071</ID_Num>
<RoleTrans>Drv(ACC)</RoleTrans>
<RoleNumber>2</RoleNumber>
<AddressFullText>1493 CRESTHAVEN LN,SAN JOSE, CA, 95118</AddressFullText>
<AddressStreetText>1493 CRESTHAVEN LN</AddressStreetText>
<AddressCityStateZip>SAN JOSE, CA, 95118</AddressCityStateZip>
<City>SAN JOSE</City>
<State>CA</State>
<Zip>95118</Zip>
<StateOfIssue>CA</StateOfIssue>
<LicenseClass>01</LicenseClass>
<Sex>M</Sex>
<Hair>BLK</Hair>
<Eyes>BRO</Eyes>
<Height>5'6</Height>
<Weight>138</Weight>
<Race>A</Race>
<DateOfBirth>09-29-1984</DateOfBirth>
<BirthDateYear>1984</BirthDateYear>
<BirthDateMonth>09</BirthDateMonth>
<BirthDateDay>29</BirthDateDay>
<Age>35</Age>
<ChargeDescriptionText />
</Driver>
<Vehicle>
<BlankOption />
<ID_Num>211223</ID_Num>
<RoleTrans>Involved (ACCIDENTS&STR CHKS)</RoleTrans>
<RoleNumber>2</RoleNumber>
<ModelYear>2015</ModelYear>
<Make>VOLK</Make>
<Model>TGN</Model>
<Style>4H</Style>
<Colour>GRY/</Colour>
<StateOfIssue>CA</StateOfIssue>
<AddressFullText />
<CityState />
<Zip />
<VehicleType>1</VehicleType>
<NumberOfOccupants />
<InsuranceName>GEICO</InsuranceName>
<InsuranceExpiryDate />
</Vehicle>
<MovementProcedingCollisionB>1</MovementProcedingCollisionB>
<MovementProcedingCollisionC />
<MovementProcedingCollisionA />
<MovementProcedingCollisionE />
<VehicleOwner>
<BlankOption />
<ID_Num>442240071</ID_Num>
<RoleTrans>Drv(ACC)</RoleTrans>
<RoleNumber>2</RoleNumber>
<Seat_position />
<AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
<CityState>SAN JOSE, CA</CityState>
<Zip>95118</Zip>
<ProvStateOfIssue>CA</ProvStateOfIssue>
<Age>35</Age>
<Sex>M</Sex>
<BirthDateYear>1984</BirthDateYear>
<BirthDateMonth>09</BirthDateMonth>
<BirthDateDay>29</BirthDateDay>
</VehicleOwner>
<NameSameAsDriver />
<AddrSameAsDriver />
<TrafficUnitDriverOtherCheck />
<TrafficUnitDriverBikeCheck />
<TrafficUnitDriverParkedCheck />
<TrafficUnitPedestrianCheck />
<TrafficUnitDriverCheck>1</TrafficUnitDriverCheck>
<DispositionVehicleByOfficer />
<DispositionVehicleByDriver>1</DispositionVehicleByDriver>
<DispositionVehicleByOther />
<PriorMechanicalDefectsNone>1</PriorMechanicalDefectsNone>
<PriorMechanicalDefectsNarr />
<DescribeVehDamageUnk />
<DescribeVehDamageNone />
<DescribeVehDamageMinor />
<DescribeVehDamageMod />
<DescribeVehDamageMajor>1</DescribeVehDamageMajor>
<DescribeVehDamageRollOver />
<Damage_14 />
<Damage_13 />
<Damage_11 />
<Damage_9>1</Damage_9>
<Damage_7 />
<Damage_4 />
<Damage_3 />
<Damage_2 />
<Damage_12 />
<Damage_1 />
<Damage_10>1</Damage_10>
<Damage_8>1</Damage_8>
<Damage_6 />
<Damage_5 />
<VehicleType1 />
<VehicleType2 />
<SpecialInformationA />
<SpecialInformationB />
<SpecialInformationC />
<SpecialInformationE />
<SpecialInformationD />
<SpecialInformationF />
<SpecialInformationG />
<SpecialInformationI />
<SpecialInformationH />
<SpecialInformationJ />
<SpecialInformationK />
<SpecialInformationL />
<SpecialInformationM />
<SpecialInformationN />
<SpecialInformationO />
<OtherAssociatedFactorsC />
<OtherAssociatedFactorsB />
<OtherAssociatedFactorsA />
<OtherAssociatedFactorsE />
<OtherAssociatedFactorsF />
<OtherAssociatedFactorsG />
<OtherAssociatedFactorsH />
<OtherAssociatedFactorsI />
<OtherAssociatedFactorsJ />
<OtherAssociatedFactorsK />
<OtherAssociatedFactorsL />
<OtherAssociatedFactorsM />
<OtherAssociatedFactorsN />
<OtherAssociatedFactorsO />
<MovementProcedingCollisionD />
<MovementProcedingCollisionF />
<MovementProcedingCollisionG />
<MovementProcedingCollisionH />
<MovementProcedingCollisionI />
<MovementProcedingCollisionJ />
<MovementProcedingCollisionK />
<MovementProcedingCollisionL />
<MovementProcedingCollisionM />
<MovementProcedingCollisionN />
<MovementProcedingCollisionO />
<MovementProcedingCollisionP />
<MovementProcedingCollisionQ />
<MovementProcedingCollisionR />
<SobrietyDrugPhysicalA>1</SobrietyDrugPhysicalA>
<SobrietyDrugPhysicalC />
<SobrietyDrugPhysicalB />
<SobrietyDrugPhysicalE />
<SobrietyDrugPhysicalD />
<SobrietyDrugPhysicalF />
<SobrietyDrugPhysicalG />
<SobrietyDrugPhysicalH />
<SobrietyDrugPhysicalI />
<OnDutyEMV />
<DriverAirBag-Box-16>L</DriverAirBag-Box-16>
<DriverSafetyEquipmentUsed-Box-18>G</DriverSafetyEquipmentUsed-Box-18>
<Direction-Box-5>W</Direction-Box-5>
<OnStreetOrHighway>BRANHAM LN</OnStreetOrHighway>
<SpeedLimit>35</SpeedLimit>
<DispositionText />
<OtherAssociatedFactorsAText />
<OtherAssociatedFactorsACitedYesNO />
<CAL_T />
<MC_MX />
<CA />
<DOT />
<TCP_PSC />
</TrafficUnit>
<ReportingDistrict-AllPages>SOUTHERN</ReportingDistrict-AllPages>
<InvolvedPeople>
<InvolvedPeople_Number>1</InvolvedPeople_Number>
<Person>
<BlankOption />
<ID_Num>442240071</ID_Num>
<RoleTrans>Drv(ACC)</RoleTrans>
<RoleNumber>2</RoleNumber>
<Seat_position />
<AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
<CityState>SAN JOSE, CA</CityState>
<Zip>95118</Zip>
<ProvStateOfIssue>CA</ProvStateOfIssue>
<Age>35</Age>
<Sex>M</Sex>
<BirthDateYear>1984</BirthDateYear>
<BirthDateMonth>09</BirthDateMonth>
<BirthDateDay>29</BirthDateDay>
</Person>
<Describe_Injuries />
<InvolvedInjuryDesc />
<Witness_Only />
<Passenger_Only />
<ExtentOfInjury_Fatal />
<ExtentOfInjury_Severe />
<ExtentOfInjury_OtherVisInjury>1</ExtentOfInjury_OtherVisInjury>
<ExtentOfInjury_ComplaintOfPain>1</ExtentOfInjury_ComplaintOfPain>
<InjuredWas_driver>1</InjuredWas_driver>
<InjuredWas_Pedestrian />
<InjuredWas_Bicyclist />
<InjuredWas_Other />
<Victim_ViolentCrimeNotified />
<PartyNumber>2</PartyNumber>
<InvolvedAirBag-Box-17>L</InvolvedAirBag-Box-17>
<InvolvedSafetyEquipmentUsed-Box-19>G</InvolvedSafetyEquipmentUsed-Box-19>
<InvolvedEjection-Box-20 />
<InvolvedTransportedBy>EMS</InvolvedTransportedBy>
<InvolvedTransportedTo>GOOD SAMARITAN HOSPITAL</InvolvedTransportedTo>
<InvolvedInjuryDesc1>SWELLING AND BRUISING ON ARMS / DIZZINESS</InvolvedInjuryDesc1>
<InvolvedInjuryDesc2 />
<InvolvedInjuryDesc3 />
<Witness_Unit />
<InjuredWas_passenger />
</InvolvedPeople>
<InvolvedPeople>
<InvolvedPeople_Number>2</InvolvedPeople_Number>
<Person>
<BlankOption />
<ID_Num>442240072</ID_Num>
<RoleTrans>Inj (ACC)</RoleTrans>
<RoleNumber>1</RoleNumber>
<Seat_position />
<AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
<CityState>SAN JOSE, CA</CityState>
<Zip>95118</Zip>
<ProvStateOfIssue>CA</ProvStateOfIssue>
<Age>38</Age>
<Sex>M</Sex>
<BirthDateYear>1981</BirthDateYear>
<BirthDateMonth>12</BirthDateMonth>
<BirthDateDay>18</BirthDateDay>
</Person>
<Describe_Injuries />
<InvolvedInjuryDesc />
<Witness_Only />
<Passenger_Only />
<ExtentOfInjury_Fatal />
<ExtentOfInjury_Severe />
<ExtentOfInjury_OtherVisInjury />
<ExtentOfInjury_ComplaintOfPain />
<InjuredWas_driver />
<InjuredWas_Pedestrian />
<InjuredWas_Bicyclist />
<InjuredWas_Other />
<Victim_ViolentCrimeNotified />
<PartyNumber>2</PartyNumber>
<InvolvedAirBag-Box-17>L</InvolvedAirBag-Box-17>
<InvolvedSafetyEquipmentUsed-Box-19>G</InvolvedSafetyEquipmentUsed-Box-19>
<InvolvedEjection-Box-20 />
<InvolvedTransportedBy>EMS</InvolvedTransportedBy>
<InvolvedTransportedTo>GOOD SAM SEAT POS #3</InvolvedTransportedTo>
<InvolvedInjuryDesc1>NECK AND CHEST PAIN</InvolvedInjuryDesc1>
<InvolvedInjuryDesc2 />
<InvolvedInjuryDesc3 />
<Witness_Unit />
<InjuredWas_passenger>1</InjuredWas_passenger>
</InvolvedPeople>
<InvolvedPeople>
<InvolvedPeople_Number>3</InvolvedPeople_Number>
<Person>
<BlankOption />
<ID_Num>442240073</ID_Num>
<RoleTrans>Inj (ACC)</RoleTrans>
<RoleNumber>2</RoleNumber>
<Seat_position />
<AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
<CityState>SAN JOSE, CA</CityState>
<Zip>95118</Zip>
<ProvStateOfIssue />
<Age>6</Age>
<Sex>M</Sex>
<BirthDateYear>2013</BirthDateYear>
<BirthDateMonth>09</BirthDateMonth>
<BirthDateDay>05</BirthDateDay>
</Person>
<Describe_Injuries />
<InvolvedInjuryDesc />
<Witness_Only />
<Passenger_Only />
<ExtentOfInjury_Fatal />
<ExtentOfInjury_Severe />
<ExtentOfInjury_OtherVisInjury />
<ExtentOfInjury_ComplaintOfPain />
<InjuredWas_driver />
<InjuredWas_Pedestrian />
<InjuredWas_Bicyclist />
<InjuredWas_Other />
<Victim_ViolentCrimeNotified />
<PartyNumber>2</PartyNumber>
<InvolvedAirBag-Box-17>L</InvolvedAirBag-Box-17>
<InvolvedSafetyEquipmentUsed-Box-19>Q</InvolvedSafetyEquipmentUsed-Box-19>
<InvolvedEjection-Box-20 />
<InvolvedTransportedBy>EMS</InvolvedTransportedBy>
<InvolvedTransportedTo>GOOD SAM SEAT POS #4</InvolvedTransportedTo>
<InvolvedInjuryDesc1>BLOODY MOUTH</InvolvedInjuryDesc1>
<InvolvedInjuryDesc2 />
<InvolvedInjuryDesc3 />
<Witness_Unit />
<InjuredWas_passenger>1</InjuredWas_passenger>
</InvolvedPeople>
<InvolvedPeople>
<InvolvedPeople_Number>4</InvolvedPeople_Number>
<Person>
<BlankOption />
<ID_Num>442240075</ID_Num>
<RoleTrans>Inj (ACC)</RoleTrans>
<RoleNumber>3</RoleNumber>
<Seat_position />
<AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
<CityState>SAN JOSE, CA</CityState>
<Zip>95118</Zip>
<ProvStateOfIssue />
<Age>3</Age>
<Sex>M</Sex>
<BirthDateYear>2016</BirthDateYear>
<BirthDateMonth>08</BirthDateMonth>
<BirthDateDay>11</BirthDateDay>
</Person>
<Describe_Injuries />
<InvolvedInjuryDesc />
<Witness_Only />
<Passenger_Only />
<ExtentOfInjury_Fatal />
<ExtentOfInjury_Severe />
<ExtentOfInjury_OtherVisInjury />
<ExtentOfInjury_ComplaintOfPain />
<InjuredWas_driver />
<InjuredWas_Pedestrian />
<InjuredWas_Bicyclist />
<InjuredWas_Other />
<Victim_ViolentCrimeNotified />
<PartyNumber>2</PartyNumber>
<InvolvedAirBag-Box-17 />
<InvolvedSafetyEquipmentUsed-Box-19 />
<InvolvedEjection-Box-20 />
<InvolvedTransportedBy>EMS</InvolvedTransportedBy>
<InvolvedTransportedTo>GOOD SAM SEAT POS #6</InvolvedTransportedTo>
<InvolvedInjuryDesc1>ABDOMINAL PAIN</InvolvedInjuryDesc1>
<InvolvedInjuryDesc2 />
<InvolvedInjuryDesc3 />
<Witness_Unit />
<InjuredWas_passenger>1</InjuredWas_passenger>
</InvolvedPeople>
<Diagram />
<Diagram2 />
<AccidentDescriptionText />
<Latitude-AllPages />
<Longitude-AllPages />
<SpecialCondition />
<CountyTrans-AllPages>SANTA CLARA COUNTY</CountyTrans-AllPages>
<AccidentWeekday-1-AllPages />
<AccidentWeekday-2-AllPages />
<AccidentWeekday-3-AllPages />
<AccidentWeekday-4-AllPages />
<AccidentWeekday-5-AllPages />
<AccidentWeekday-6-AllPages />
<AccidentWeekday-7-AllPages>[X]</AccidentWeekday-7-AllPages>
<PropertyOwnerName-AllPages />
<PropertyOwnerAddress-AllPages />
<PropertyDamage-AllPages />
<OtherAssociatedFactorsKText />
<MovementProcedingCollisionRText />
<OtherAssociatedFactorsMText />
<TowAwayYes-AllPages>1</TowAwayYes-AllPages>
<OtherAssociatedFactorsKCitedYesNo />
<JudicialDistrict-AllPages>43470</JudicialDistrict-AllPages>
<PreparersDate-AllPages>02-01-2020</PreparersDate-AllPages>
<ApprovedBy-AllPages />
<Description>
<NarrativeText>
<LINE>SUMMARY: On 2-1-20 at about 1547 hrs, emergency services responded to a two-vehicle collision on</LINE>
<LINE>Branham Ln at Pinmore Dr. Upon police arrival both vehicles were disabled in the roadway. </LINE>
<LINE>Fire/medics assessed all parties for injuries.</LINE>
<LINE />
<LINE>STATEMENTS:</LINE>
<LINE />
<LINE> D-1(White) identified herself as the drive of V-1(Toyt) with her CDL. D-1 stated that she was</LINE>
<LINE>making a left turn from the Safeway parking lot to eastbound Branham Ln when she was abruptly struck</LINE>
<LINE>by V-2(Volk). D-1 said she did not see V-2 approached and speculated that D-2 may have been</LINE>
<LINE>speeding. D-1 had a complaint of pain across her neck but declined medical transport.</LINE>
<LINE />
<LINE> D-2(Joo) identified himself as the driver of V-2(Volk) with his CDL. D-2 stated that he was</LINE>
<LINE>simply driving approximately 35 mph in the #1 lane of westbound Branham Ln when V-1(Toyt) abruptly</LINE>
<LINE>pulled out in front of him. D-2 stated that he swerved to avoid colliding, however, he had little</LINE>
<LINE>time to react.</LINE>
<LINE />
<LINE>INJURIES: All 4 occupants of V-2 were transported by ambulance for further assessment of minor to</LINE>
<LINE>moderate injuries.</LINE>
<LINE />
<LINE>CAUSE: D-1(White) caused the collision when she failed to yield to all vehicles approaching from</LINE>
<LINE>opposite direction close enough to be a hazard during any part of the turn in violation of 21801(a)</LINE>
<LINE>VC.</LINE>
</NarrativeText>
</Description>
<PreparersName-AllPages>CRAIG,CHRISTOPHER J (3961)</PreparersName-AllPages>
<AccidentReportNumber-AllPages>2020-200320523</AccidentReportNumber-AllPages>
<PreparersID-AllPages>3961</PreparersID-AllPages>
<NCIC-AllPages>4313</NCIC-AllPages>
<ApprovedDate-AllPages />
<chkCollOther-AllPages />
<chkTypeSupp_BAUpdate-AllPages />
<chkTypeSupp_HazMat-AllPages />
<chkTypeSupp_Fatal-AllPages />
<chkTypeSupp_SBus-AllPages />
<chkTypeSupp_HitandRun-AllPages />
<chkTypeSupp_Other-AllPages />
<Other_text-AllPages />
<Coll_Other_text-AllPages />
<CitationNumber-AllPages />
<Beat-AllPages>A1</Beat-AllPages>
<chkStateHywRelated-AllPages />
<chkNarrative-AllPages>1</chkNarrative-AllPages>
<Municipality-AllPages>SAN JOSE</Municipality-AllPages>
<Subject-AllPages />
<SpecialCondition-AllPages />
<NumberInjured-AllPages>4</NumberInjured-AllPages>
<NumberKilled-AllPages />
<HitAndRunFelony-AllPages />
<HitAndRunMisdemeanor-AllPages />
<PhotographsBy-AllPages />
<PhotographsNone-AllPages />
<StateHywRelYesNo-AllPages>0</StateHywRelYesNo-AllPages>
<MilePostInfo1-AllPages />
<MilePostInfo2-AllPages />
<MilePostInfo3-AllPages />
<AtIntersection1-AllPages />
<AtIntersection2-AllPages />
<AtIntersection3-AllPages />
<DispatchNotifiedY-AllPages />
<DispatchNotifiedN-AllPages />
<DispatchNotifiedNA-AllPages />
<ProperyDamageNotifiedYesNo-AllPages />
<AccidentDescriptionText-AllPages />
<AtIntersectionWith-AllPages />
<PrimaryCollisionA-AllPages>1</PrimaryCollisionA-AllPages>
<PrimaryCollisionB-AllPages />
<PrimaryCollisionC-AllPages />
<PrimaryCollisionD-AllPages />
<VCSectionViolatedText-AllPages>21801(a) VC</VCSectionViolatedText-AllPages>
<PrimaryCollisionBText-AllPages />
<VCSectionViolatedCitedYes-AllPages>0</VCSectionViolatedCitedYes-AllPages>
<WeatherA-AllPages>1</WeatherA-AllPages>
<WeatherB-AllPages />
<WeatherC-AllPages />
<WeatherD-AllPages />
<WeatherE-AllPages />
<WeatherF-AllPages />
<WeatherG-AllPages />
<Weather_visibility-AllPages />
<WeatherOther-AllPages />
<LightingA-AllPages>1</LightingA-AllPages>
<LightingB-AllPages />
<LightingC-AllPages />
<LightingD-AllPages />
<LightingE-AllPages />
<RoadwaySurfaceA-AllPages>1</RoadwaySurfaceA-AllPages>
<RoadwaySurfaceB-AllPages />
<RoadwaySurfaceC-AllPages />
<RoadwaySurfaceD-AllPages />
<RoadwayConditionsA-AllPages />
<RoadwayConditionsB-AllPages />
<RoadwayConditionsC-AllPages />
<RoadwayConditionsD-AllPages />
<RoadwayConditionsE-AllPages />
<RoadwayConditionsF-AllPages />
<RoadwayConditionsG-AllPages />
<RoadwayConditionsH-AllPages>1</RoadwayConditionsH-AllPages>
<TrafficControlDevicesA-AllPages />
<TrafficControlDevicesB-AllPages />
<TrafficControlDevicesC-AllPages />
<TrafficControlDevicesD-AllPages>1</TrafficControlDevicesD-AllPages>
<TypeOfCollisionA-AllPages />
<TypeOfCollisionB-AllPages />
<TypeOfCollisionC-AllPages />
<TypeOfCollisionD-AllPages>1</TypeOfCollisionD-AllPages>
<TypeOfCollisionE-AllPages />
<TypeOfCollisionF-AllPages />
<TypeOfCollisionG-AllPages />
<TypeOfCollisionH-AllPages />
<MotorVehicleInvolvedWithA-AllPages />
<MotorVehicleInvolvedWithB-AllPages />
<MotorVehicleInvolvedWithC-AllPages>1</MotorVehicleInvolvedWithC-AllPages>
<MotorVehicleInvolvedWithD-AllPages />
<MotorVehicleInvolvedWithE-AllPages />
<MotorVehicleInvolvedWithF-AllPages />
<MotorVehicleInvolvedWithG-AllPages />
<MotorVehicleInvolvedWithH-AllPages />
<MotorVehicleInvolvedWithI-AllPages />
<MotorVehicleInvolvedWithJ-AllPages />
<PedestrianActionA-AllPages>1</PedestrianActionA-AllPages>
<PedestrianActionB-AllPages />
<PedestrianActionC-AllPages />
<PedestrianActionD-AllPages />
<PedestrianActionE-AllPages />
<PedestrianActionF-AllPages />
<PedestrianActionG-AllPages />
<MotorVehicleInvolvedWithHText-AllPages />
<MotorVehicleInvolvedWithIText-AllPages />
<MotorVehicleInvolvedWithJText-AllPages />
<CollisionOccurredOn2-AllPages>PINMORE DR</CollisionOccurredOn2-AllPages>
<CollisionOccurredOn1-AllPages>BRANHAM LN</CollisionOccurredOn1-AllPages>
<RoadwayCGText-AllPages />
<TypeOfCollisionHText-AllPages />
<OtherAssocFactorsFCode-Box-22 />
<CollisionOccurredDate-AllPages>02-01-2020</CollisionOccurredDate-AllPages>
<Time-AllPages>1547</Time-AllPages>
</agency>
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
Unable to query xml data in sql server chris H <chris.sjpd@gmail.com> - 2020-06-10 09:29 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-06-10 21:55 +0200
Re: Unable to query xml data in sql server chris H <chris.sjpd@gmail.com> - 2020-06-10 13:05 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-06-10 23:42 +0200
Re: Unable to query xml data in sql server chris H <chris.sjpd@gmail.com> - 2020-06-10 14:50 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-06-11 00:15 +0200
Re: Unable to query xml data in sql server chris H <chris.sjpd@gmail.com> - 2020-06-10 15:30 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-06-11 21:04 +0200
Re: Unable to query xml data in sql server chris <chris.sjpd@gmail.com> - 2020-06-12 15:54 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-06-13 10:36 +0200
Re: Unable to query xml data in sql server chris <chris.sjpd@gmail.com> - 2020-06-17 13:13 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-06-18 08:29 +0200
Re: Unable to query xml data in sql server chris <chris.sjpd@gmail.com> - 2020-06-18 16:30 -0700
Re: Unable to query xml data in sql server chris <chris.sjpd@gmail.com> - 2020-06-18 16:47 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-06-19 10:24 +0200
Re: Unable to query xml data in sql server chris <chris.sjpd@gmail.com> - 2020-06-29 16:56 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-06-30 20:39 +0200
Re: Unable to query xml data in sql server chris <chris.sjpd@gmail.com> - 2020-07-13 14:25 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-07-14 11:49 +0200
Re: Unable to query xml data in sql server chris <chris.sjpd@gmail.com> - 2020-07-14 09:56 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-07-14 19:59 +0200
Re: Unable to query xml data in sql server chris <chris.sjpd@gmail.com> - 2020-07-15 15:20 -0700
Re: Unable to query xml data in sql server chris <chris.sjpd@gmail.com> - 2020-08-04 09:17 -0700
Re: Unable to query xml data in sql server Erland Sommarskog <esquel@sommarskog.se> - 2020-08-04 21:29 +0200
csiph-web