I need a recursive SQL Query which will specify the parent and child from a large list in the same format as as the [url removed, login to view] file and the expected output as the [url removed, login to view] file.
Input file issues:
• Reversed duplicated (double) entry
• No categorisation of master and slave accounts as each account number is contained within both columns (related to point above)
• Any account number can have any number of relations and relations can have an unlimited depth (many to many relationships)
The requirement is to create a list of accounts which would specify the master and slave accounts.
Please only bid when complete and I will pay after testing.
12 freelancers are bidding on average $25 for this job
I'm a new freelancer. So I doesn't have reviews. But I confirm you I can do this work very well..... Relevant Skills and Experience Excel SQL MYSQL Proposed Milestones $10 USD - One milestone payment
Query (or store procedure) that generates a view for the requirement. Relevant Skills and Experience Database Admin (Mysql, MSSQL, Postgres and Oracle) Proposed Milestones $25 USD - Query