"happyd119" <happyd119@discussions.microsoft.com> wrote in message
news:12D8D6C2-0BE1-4ACB-8464-A537F50860D9@microsoft.com...
> Hi,
>
> I tried to use report parameter with a stoed procedure that its parameter
> type is UNIQUEIDENTIFER. When I execute the data set, I got ivalid data
> type
> converting error (Syste.String -> String.Guid). Is ther a way to pass
> GUID
> as parmeter value to stored procedure?
>
> Thanks

"Wayne Snyder" wrote:

> The problem is that SQL does not implicitly convert a string ( which is your
> parameter type - there is no guid parameter type ) to a GUID... So, define
> the parameter in SQL as a Char (36), then convert it to a guid in the SP ie
>
> create proc myproc ( @myCharGuid char(36) )
> as
>
> Declare @myGuid uniqueidentifier
> Select @myGuid = convert(uniqueidentifier, @myCharGuid)
>
> Hope this helps
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "happyd119" <happyd119@discussions.microsoft.com> wrote in message
> news:12D8D6C2-0BE1-4ACB-8464-A537F50860D9@microsoft.com...
> > Hi,
> >
> > I tried to use report parameter with a stoed procedure that its parameter
> > type is UNIQUEIDENTIFER. When I execute the data set, I got ivalid data
> > type
> > converting error (Syste.String -> String.Guid). Is ther a way to pass
> > GUID
> > as parmeter value to stored procedure?
> >
> > Thanks
>
>