Posted by Mike R on 03/09/06 18:14

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: Update a uniqueidentifier from a string!!!
• Prev in forum: Re: Speed up Bulk Update
• Thread view: Update a uniqueidentifier from a string!!!

[Reply to this message]