T-SQL to Merge Accounts for User in Database
Budget: $10 – $30 USD
This if is for an application user that has duplicate accounts in a large enterprise application with thousands of tables. Use the Correct Account and Duplicate Account as the seed values and search the database for tables that have the seed accounts. Show a Display that lists by table the Correct Account rows, and Duplicate Account rows. Sql Server 2016, Use only T-SQL if possible. If it needs a Display page use c#, .net, Azure DevOps, Jira+Confluence, Snowflake.
Show a checkbox to select all Duplicate records and copy those to the Correct Account number.
Show a checkbox to select each of Duplicate records and copy those to the Correct Account number.
The column for the seed account is IDNUMBER
Correct Account IDNUMBER 11111
Duplicate Account IDNUMBER 11112
Display
table1
Correct Account has Rows
11111,1,2,3,4,5,a,b
11111,1,2,3,4,1,f,b
11111,1,2,4,4,5,a,f
Wrong Account has Rows
11112,4,5,6,7,6c,d
11112,4,5,6,7,6c,e
table2
Correct Account has Rows
11111,1,2,3,e,f
11111,1,1,3,e,g
Wrong Account has Rows
11112,4,5,6,g,f
11112,4,5,3,g,j
50 more tables possible
Please reply with:
The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Will you require contact by voice and do you speak English? When you can complete the project.
Confidentiality.
a) No Use. Recipient agrees not to use the Confidential Information in any way, or to manufacture or test any product embodying Confidential Information, except for the purpose set forth above.
b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof, from disclosure to any person other than Recipient's employees having a need for disclosure in connection with Recipient's authorized use of the Confidential Information.
c) Protection of Secrecy. Recipient agrees to take all steps reasonably necessary to protect the secrecy of the Confidential Information, and to prevent the Confidential Information from falling into the public domain or into the possession of unauthorized persons.
d) Scope. The scope of Confidentiality is deemed to be in all contracts present past and future with the Parties to this request
Show a checkbox to select all Duplicate records and copy those to the Correct Account number.
Show a checkbox to select each of Duplicate records and copy those to the Correct Account number.
The column for the seed account is IDNUMBER
Correct Account IDNUMBER 11111
Duplicate Account IDNUMBER 11112
Display
table1
Correct Account has Rows
11111,1,2,3,4,5,a,b
11111,1,2,3,4,1,f,b
11111,1,2,4,4,5,a,f
Wrong Account has Rows
11112,4,5,6,7,6c,d
11112,4,5,6,7,6c,e
table2
Correct Account has Rows
11111,1,2,3,e,f
11111,1,1,3,e,g
Wrong Account has Rows
11112,4,5,6,g,f
11112,4,5,3,g,j
50 more tables possible
Please reply with:
The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Will you require contact by voice and do you speak English? When you can complete the project.
Confidentiality.
a) No Use. Recipient agrees not to use the Confidential Information in any way, or to manufacture or test any product embodying Confidential Information, except for the purpose set forth above.
b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof, from disclosure to any person other than Recipient's employees having a need for disclosure in connection with Recipient's authorized use of the Confidential Information.
c) Protection of Secrecy. Recipient agrees to take all steps reasonably necessary to protect the secrecy of the Confidential Information, and to prevent the Confidential Information from falling into the public domain or into the possession of unauthorized persons.
d) Scope. The scope of Confidentiality is deemed to be in all contracts present past and future with the Parties to this request
Related categories:
SQL
C# Programming
ASP.NET
Microsoft SQL Server
T-SQL (Transact Structures Query Language)