Re: Problem with Dates and OpenXML command

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Adam Machanic" <amachanic@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Sat, 5 Nov 2005 14:52:23 -0500

Can you show a sample of the XML and the OPENXML syntax you're using?

--
Adam Machanic
Pro SQL Server 2005, available now
www.apress.com/book/bookDisplay.html?bID=457
--

"Paul Barnett" <barnettpaul@xxxxxxxxx> wrote in message
news:eCtAwfM4FHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
>
>
> My data is being updated correctly for all fields except a date field.
> The program is crashing when a date is encountered with OpenXML. Is
> there a way to convert the date within SQL to handle this...I have tried
> the CONVERT statement below, but it does little
>
>
>
> UPDATE EducationSheetSchool
> SET
> EducationSheetSchool.Address= XMLEducationSheetSchool.Address,
> EducationSheetSchool.[Name]= XMLEducationSheetSchool.[Name],
> EducationSheetSchool.LEA= XMLEducationSheetSchool.LEA,
> EducationSheetSchool.Tel= XMLEducationSheetSchool.Tel,
> EducationSheetSchool.Email= XMLEducationSheetSchool.Email,
>
> EducationSheetSchool.Start=CONVERT(varchar(30),XMLEducationSheetSchool.S
> tart, 126),
>
> *** Sent via Developersdex http://www.developersdex.com ***

.

References:
- Problem with Dates and OpenXML command
  - From: Paul Barnett

Prev by Date: Re: DELETING 100 million from a table weekly SQl SERVER 2000
Next by Date: Re: DELETING 100 million from a table weekly SQl SERVER 2000
Previous by thread: Problem with Dates and OpenXML command
Next by thread: Query Analyzer
Index(es):
- Date
- Thread