mrmmickle1
Well-known Member
- Joined
- May 11, 2012
- Messages
- 2,461
I have two tables with the same fields. One is named PendingErrors and the other is named PendingImportBilling.
The fields are as follows:
Excel 2012
<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>
I want to update the PendingErrors Table with only records that do not already exist in it.
BEFORE EXAMPLES
ie. Pending Errors:
Excel 2012
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
PendingImportBilling:
Excel 2012
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Pendingerrors After SQL Query:
Excel 2012
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I would like to insert only the records that do not currently have an Accession ID in Pending Errors. I would like the entire record (With ALL Fields) inserted into PendingErrors. Not just the Payor Name likein the simplified example.
If someone could help me out it would be much appreciated!
Thanks for looking at my issue.
The fields are as follows:
Excel 2012
A | |
---|---|
1 | Accession ID |
2 | Payor Name |
3 | Error Date |
4 | Error Code |
5 | Error Code Description |
6 | Patient First Name |
7 | Patient Last Name |
8 | Patient DOB |
9 | Patient Home Phone |
10 | Insured Home Phone |
11 | Client Billing Phone |
12 | Note |
13 | Client ID |
14 | Client Name |
15 | Subscriber ID |
16 | Insured SSN |
17 | Patient SSN |
18 | Patient Full Address |
19 | Responsible |
20 | Category |
21 | Type |
<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
I want to update the PendingErrors Table with only records that do not already exist in it.
BEFORE EXAMPLES
ie. Pending Errors:
Excel 2012
A | B | |
---|---|---|
1 | Accession ID | Payor Name |
2 | 1111 | AAA |
3 | 22222 | AAA |
4 | 33333 | AAA |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
PendingImportBilling:
Excel 2012
A | B | |
---|---|---|
8 | Accession ID | Payor Name |
9 | 1111 | BBB |
10 | 22222 | BBB |
11 | 33333 | BBB |
12 | 44444 | BBB |
13 | 55555 | BBB |
14 | 66666 | BBB |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Pendingerrors After SQL Query:
Excel 2012
A | B | |
---|---|---|
1 | Accession ID | Payor Name |
2 | 1111 | AAA |
3 | 22222 | AAA |
4 | 33333 | AAA |
5 | 44444 | BBB |
6 | 55555 | BBB |
7 | 66666 | BBB |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
I would like to insert only the records that do not currently have an Accession ID in Pending Errors. I would like the entire record (With ALL Fields) inserted into PendingErrors. Not just the Payor Name likein the simplified example.
If someone could help me out it would be much appreciated!
Thanks for looking at my issue.