I am getting this error on the query below
Msg 8169, Level 16, State 2, Line 1
Conversion failed when converting from a character string to uniqueidentifier.
SELECT [Contract].vidyo_enduseridName,
[Contract].ContractNumber,
[Contract].BillingCustomerIdName,
[Contract].Vidyo_ContractCategory,
[Contract].TotalPrice, [Contract].
ActiveOn, [Contract].ExpiresOn,
[Contract].StatusCode,
[Contract].Vidyo_ServiceLevelHWIdName,
[Contract].Vidyo_ServiceLevelHWId,
[Contract].TransactionCurrencyIdName,
ContractDetail.ProductIdName,
ContractDetail.Vidyo_FQDN,
ContractDetail.Vidyo_ARMA,
ContractDetail.vidyo_serialnumberidName,
ContractDetail.vidyo_servicelevelidName,
ContractDetail.Vidyo_MACAddress, [Contract].ContractId
FROM Vidyo_MSCRM.dbo.[Contract]
INNER JOIN Vidyo_MSCRM.dbo.ContractDetail ContractDetail ON ([Contract].ContractId=ContractDetail.ContractId)
AND ([Contract].AccountId=ContractDetail.AccountId)
WHERE [Contract].ContractId='CNR-67079-R3BD5K'
Can someone please help me to fix this error please?
Thanks - Paul