Post reply

OPENXML() is there a way to force WITH clause to parse based on an UDT ?

  • February 11, 2020 at 7:40 pm

    #3724891

    Concrete:

    CREATE TABLE DestinationTypeTest  ( LocationName VARCHAR(50),CostRate INT,ExpiryDate DATETIME)

    SELECT * FROM OPENXML (@idoc, '/RootElement', 2) WITH DestinationTypeTest   <-- parses OK


    CREATE TYPE DestinationType4SPROC AS TABLE (
    LocationName VARCHAR(50),
    CostRate INT,
    ExpiryDate DATETIME
    )

    SELECT * FROM OPENXML (@idoc, '/RootElement', 2) WITH DestinationType4SPROC   <-- ????

  • February 12, 2020 at 8:10 pm

    #3725355

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply