3 Replies Latest reply on Sep 17, 2010 10:27 AM by fireworks12

    SQL Statement Info Editor

    Arnej6511 Level 1

      I have a datatype in a table as uniqueidentifer. In the SQL statement Editor I'm trying to map my Xpath to the statement.


      An Error is thrown: cannot cast uniqueidentifier to varchar. I have tried all the functions and data types I can think of.



      EXEC SetSomeSP  @ProcessID = {$/process_data/@ProcessID$}


      I have tired with quotes, casting with functions and using parameterized query with no luck.


      Any help would be great.