OPENXML with INSERT

• Chris Lee-152270

  SSCommitted

  Points: 1809

  More actions

  May 27, 2008 at 10:42 am

  #188263

  Hi,

  I have SQL 2005 ENT on Windows 2003 server and try to insert XML data into a table variable:

  '

  '

  I know following statement does not work since RequestID and AppName are differnt level from RequestPeopleID, Login, Passwork, TaskID and Status:

  INSERT INTO @Request(RequestID, AppName, RequestPeopleId, Login, Password, TaskID, Status)

  SELECT RequestID, AppName, RequestPeopleId, Login, Password, TaskID, Status

  FROM OPENXML (@idoc, '/R/A/RP', 2)

  WITH (RequestID INT '../@RequestID'

  ,AppName VARCHAR(50) '../@AppName'

  ,RequestPeopleId VARCHAR(30) '@RequestPeopleId'

  ,Login VARCHAR(100) '@Login'

  ,Password VARCHAR(30) '@Password'

  ,TaskID INT '@TaskID'

  ,Status BIT '@Status')

  Is there a work around? Thanks for any hint.

  Chris

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  May 30, 2008 at 3:18 am

  #822166

  Your XML didn't make it accross. Can you make it accessible on a URL?

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com