this type of error
i have use the
WHERE a.GUIDRef = convert(uniqueidentifier,@GUIDRef)
@GUIDRef nvarchar(300)
Conversion failed when converting from a character string to uniqueidentifier.