Posted by Jack Vamvas on 03/09/06 18:29

Is it possible that you have an unacceptable character in the string? That
will not allow it to convert into a uniqueidentifier
Must be in the range 0-9 or a-f
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm


"Mike R" <noreturnaddress@hotmail.co.uk> wrote in message
news:dupk91$otg$1$8302bc10@news.demon.co.uk...
> Hi,
>
> I have this simple bit of SQL
>
> UPDATE A
> SET a.owninguser = c.companyname
> --select a.owninguser,c.companyname
> from campaignresponsebase c
> inner join activitypointerbase a on a.activityid = c.activityid
> WHERE Companyname is not null
>
> Companyname contains a string which happens to be a guid. Owninguser is a
> guid.
>
> I keep getting
>
> Server: Msg 8169, Level 16, State 2, Line 1
> Syntax error converting from a character string to uniqueidentifier.
>
> When I run this, I have also tried CAST(c.companyname as uniqueidentifier)
> and still get the same.
>
> Any pointers?
>
> Thanks
>
> Mike
>
>

• Next in forum: Re: Can't fit results of tsql query in excel
• Prev in forum: Update a uniqueidentifier from a string!!!
• Thread view: Re: Update a uniqueidentifier from a string!!!

[Reply to this message]