I have a query that failing with this error:
"Error converting data type nvarchar to bigint"
My line that's failing is this:
INNER JOIN Country ON ColMeta.xCountry = Country.countryID
ColMeta.xCountry is nvarchar(1000)
Country.countryID = bigint
Is there a way to convert this on the fly (here in the query) without having to modify the database tables?