|
| Group: |
comp.databases.ms-sqlserver |
[ Post new message ] |
|
|
 |
| Author: |
JJ297 |
| Subject: |
Re: Stored procedure Question |
| Body: |
On Oct 10, 11:28=A0am, Plamen Ratchev <Pla...@SQLStudio.com> wrote:
> You simply insert all values to the Diaries table, then run the DELETE
> statement I posted. There is no need for the HoldingTable and all other
> queries you posted.
>
> --
> Plamen Ratchevhttp://www.SQLStudio.com
Okay that did it but I worded it wrong as to what I want.
When I compare the two files I want the dups to be deleted and the
single occurrences to remain in the table. I'm looking for the
cleared items and if there are dups then they are not cleared. Single
occurrences are cleard so I want them to be placed in the Diaries
table. So I should have Pan 1 Pan 3, and Pan 4 only in the Diaries
table as Pan 2 had duplicates. I hope this makes sense.
|
|
|
|
| Topic: |
Stored procedure Question |
|
| Message: |
Author |
Date |
|
|
*Message 1* |
JJ297 |
Fri, 10 Oct 2008, 8:37 am |
|