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

    SQL Statement Info Editor

    Arnej6511

      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.

       

      ex

      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.