why conversion error?

7 Sep 2007 2:02 AM

ChrisHarrington

declare @cid uniqueidentifier
declare @pid uniqueidentifier
set @cid = '0F88363A-5689-42E1-8A1A-86228B9C23C5'
set @pid = 'C8F5598F-2A72-4E8D-A833-00C9F152130D'
exec dbo.sp_GetReportXml @cid,@pid
go

gives error

"Conversion failed when converting from a character string to
uniqueidentifier. "

Also tried with '{ ...}' - same error.

Chris Harrington
Active Interface, LLC.
http://www.activeinterface.com

7 Sep 2007 2:32 PM

ChrisHarrington

Never mind - error was in stored proc.

Show quote

"ChrisHarrington" <charrington-at-activeinterface.com> wrote in message
news:enRKXMP8HHA.3716@TK2MSFTNGP03.phx.gbl...
>
>
>
> declare @cid uniqueidentifier
> declare @pid uniqueidentifier
> set @cid = '0F88363A-5689-42E1-8A1A-86228B9C23C5'
> set @pid = 'C8F5598F-2A72-4E8D-A833-00C9F152130D'
> exec dbo.sp_GetReportXml @cid,@pid
> go
>
> gives error
>
> "Conversion failed when converting from a character string to
> uniqueidentifier. "
>
>
>
> Also tried with '{ ...}' - same error.
>
>
> Chris Harrington
> Active Interface, LLC.
> http://www.activeinterface.com
>
>