<div>
I'm not getting any error from in the stored procedure. My problem is that I am calling the stored procedure from Crystal Reports and passing a varchar as a parameter to a uniqueidentifier. I guess I can pass it to a varchar and then do the conversion, but I am in a situation where I need to use the stored procedures that have been in use for quite some time by other applications, in other words, I can't make any changes to the stored procedure, and they don't want me to create any new ones either.<br />
<br />
Please help.
</div>


I'm not getting any error from in the stored procedure. My problem is that I am calling the stored procedure from Crystal Reports and passing a varchar as a parameter to a uniqueidentifier. I guess I can pass it to a varchar and then do the conversion, but I am in a situation where I need to use the stored procedures that have been in use for quite some time by other applications, in other words, I can't make any changes to the stored procedure, and they don't want me to create any new ones either.

Please help.

<div>
Can you profile the actual call to the procedure to verify how it is being passed? &nbsp;
</div>


Can you profile the actual call to the procedure to verify how it is being passed?  

<div>
Thank you for your help. I was able to convince the powers that be to let me create a new stored procedure.<br />
<br />
By the way, I'm pretty sure the parameter is being passed as a string.
</div>


Thank you for your help. I was able to convince the powers that be to let me create a new stored procedure.

By the way, I'm pretty sure the parameter is being passed as a string.

<div>
<div class="content wysiwyg-content">
I am trying to call a stored procedure from Crystal Reports and I'm passing a parameter. I need the parameter to be a uniqueidentifier datatype, but it is being treated as a varchar. Is there a way to convert the varchar to uniqueidentifer before passing it as a parameter? is there maybe another solution to this problem?<br />
<br />
Please help
</div>
</div>


I am trying to call a stored procedure from Crystal Reports and I'm passing a parameter. I need the parameter to be a uniqueidentifier datatype, but it is being treated as a varchar. Is there a way to convert the varchar to uniqueidentifer before passing it as a parameter? is there maybe another solution to this problem?

Please help

Error Converting Varchar to uniqueidentifier

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.