Find Jobs
Hire Freelancers

convert oracle sql query (with joins) to ms sql

€8-30 EUR

En curso
Publicado hace alrededor de 7 años

€8-30 EUR

Pagado a la entrega
the situation: a MS SQL Server is connected to a Oracle DB server (linked, OLE), since the client software does not support oracle. the connection is only used for read requests. The ERP software company provided a oracle query with two joins (+) this one should be converted, so that the MS SQL side can get the data linked server works, typical select queries are not a problem. if you read the description, please add "got it" to your answer the oracle part (select removed): FROM PRDOP t1, PRD t2, CUST0015 t3, KADR t4, ART t5 WHERE (([login to view URL] = 55166.000) AND ([login to view URL] = 20)) AND (([login to view URL] = [login to view URL] (+) )) and [login to view URL] = [login to view URL] and [login to view URL] = [login to view URL] (+) and [login to view URL] = [login to view URL]; remote sql execute prefered, since it should be fast. the oracle sql query works on the oracle side. work is completed, when the query gets the same results on the ms sql and orace side.
ID del proyecto: 12882049

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
3 freelancers están ofertando un promedio de €24 EUR por este trabajo
Avatar del usuario
Hi, I have gone through your project details and would like to take an opportunity to work on it. Being experienced in working on Oracle SQL queries professionally and have experienced of working on MS SQL database, I can help you on conversion work efficiently and in quick time. Waiting for your response for detailed discussion. Thanks.
€19 EUR en 0 día
4,8 (105 comentarios)
6,0
6,0
Avatar del usuario
Hello client, i can convert oracle sql query (with joins) to ms sql  My skills are PHP, Yii, code igniter, MySQL, Apache, Redis. Experience with API development and integration. - all site were done by me from 0. I got just PSD files and did all responsive HTML coding for MAC/Win: FF/Chrome/IE/Safari Thank you for sharing such interesting project and opportunity to bid on it. Regards Ruchi
€23 EUR en 1 día
5,0 (6 comentarios)
4,8
4,8
Avatar del usuario
"got it" Hello. Thank you very much for taking time to read my proposal. I can do it. We can discuss further details. Hopefully, both of us will be happy after the job is done. Best Regards.
€29 EUR en 1 día
5,0 (16 comentarios)
4,0
4,0

Sobre este cliente

Bandera de SWITZERLAND
Altstätten, Switzerland
5,0
2
Forma de pago verificada
Miembro desde ene 9, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.