Error en consulta SQL

Kaos #1 Ene '22 Administrador

Qué pasa gente. Tengo una consulta SQL que me está petando:

SELECT _id, CAST(empresa AS nvarchar) COLLATE Modern_Spanish_CI_AS AS empresa, CAST(serie AS nvarchar) COLLATE Modern_Spanish_CI_AS AS serie, numero, num_asiento, CAST(desc_asiento AS nvarchar) COLLATE Modern_Spanish_CI_AS AS desc_asiento, CAST(num_factura AS nvarchar(255)) COLLATE Modern_Spanish_CI_AS AS num_factura, fecha_recepcion, CAST(proveedor AS nvarchar) COLLATE Modern_Spanish_CI_AS AS proveedor, CAST(nif AS nvarchar) COLLATE Modern_Spanish_CI_AS AS nif, amount
FROM OPENQUERY([SVQ-SWERP], 'execute TRICHODEX.dbo.RetrieveAllInvoices') AS derivedtbl_1

Antes de actualizar el servidor SQL funcionaba. Debe ser algo que ha quedado deprecated...

El error es:

¿Se os ocurre algo?

FROM OPENQUERY([SVQ-SWERP], 'execute TRICHODEX.dbo.RetrieveAllInvoices WITH RESULT SETS(( _id nvarchar, empresa nvarchar, serie nvarchar, numero int, num_asiento int, id_asiento int, ref_asiento nvarchar, desc_asiento nvarchar, num_factura nvarchar, fecha_recepcion datetime, proveedor nvarchar, nif nvarchar, amount int ))') AS derivedtbl_1

Error en consulta SQL

Usuarios habituales

Tags