convert oracle sql query (with joins) to ms sql

€8-30 EUR

Σε Εξέλιξη

Αναρτήθηκε

πάνω από 7 χρόνια πριν

€8-30 EUR

Πληρωμή κατά την παράδοση

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.

Microsoft SQL Server

Oracle

Software Architecture

SQL

Ταυτότητα εργασίας: 12882049

Σχετικά με την εργασία

3 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

3 freelancers δίνουν μια μέση προσφορά €24 EUR για αυτή τη δουλειά

@mail2vimalarora

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 σε 0 ημέρα

4,8

(105 αξιολογήσεις)

6,0

@ruchiakhani

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 σε 1 ημέρα

5,0

(6 αξιολογήσεις)

4,8

@celalaybar

"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 σε 1 ημέρα