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