Forum Discussion
Anonymous
6 years agoNot applicable
Conversion failed when converting from a character string to uniqueidentifier
I'm getting the following error on a table from SQL Server: OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Conversion failed when converting from a character string to uniqueidentifier.. D...
mwegener
6 years agoMost Valuable Professional
Hi Anonymous
is vps_Sum an SQL table or view?
What happens if you query
SELECT * FROM [dbo].[vps_Sum]
in SQL Management Studio
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Anonymous
3 years agoNot applicable
This was the solution for me. We were trying to join nvachar to a uniqeidentifier, which is fine, but breaks if the field is empty