Information générale
Forum:
Microsoft SQL Server
Hi Mike
We have made some progress. We found that by adding the "convert" function to our query, the sp executes without an error. This indicates corrupt data in my mind, although we have not been able to "eye-ball" the corrupt data in the source tables.
So now we have to ways of "fixing" the problem. (1) convert the data before writing to the table and (2) rewrite the query to remove the subquery.
If we have corrupt data, then using the convert function makes sense. I have no understanding of why rewriting the query works.
Keith
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement