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.
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.
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
"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.