I'm trying to insert data from one table to another.
The source table contains an nvarchar field right now that has guids as text.
I want to insert it into a new table that has a UniqueIdentifier field.
This is the query and the error.
insert into Tag
select cast(ID as uniqueidentifier),
cast('71479D27-D7A2-4439-99CB-0B536DCEFB45' as uniqueidentifier),
cast('49493D4F-A0B0-43A5-8B32-45572E4D7E43' as uniqueidentifier)
Msg 8169, Level 16, State 2, Line 1
Conversion failed when converting from a character string to uniqueidentifier.