SQL Statement Info Editor

[Former Community Member]

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.

[Former Community Member]

single quotes worked, but there is a limit to the buffer size for the xpath. I found that certain paths were too long for it to process.

[Jasmin_Charbonn]

I wonder if you can get around the buffer size issue with a parametrized query.

Your query would look like

EXEC SetSomeSP  @ProcessID = ?

Jasmin

[fireworks12]

How about a shorter string?