...
Datum von: Heute minus 60 TageDatum bis: leerBenutzer: leerSuchziel: 2 | ‚Für SB' und ‚Von' durchsuchenTerminart: Alle Terminarten, welche auch in A4OlSync eingestellt sind. "Auch erledigte Termine anzeigen" aktivieren
Markieren Sie alle Terminduplikate, in diesem Beispiel die unteren 5 Stück, per Menüpunkt "Bearbeiten" > "Löschen" oder Entfernen-Taste sind diese zu löschen.
Ist die Löschung aller Terminduplikate auf diesem Weg zu zeitaufwendig, beispielsweise weil es hunderte oder tausende Terminduplikate gibt – so wechseln Sie zu Schritt 2.
- Verbinden Sie sich per Remotedesktopverbindung auf den Datenbankserver und starten Sie Microsoft SQL Management Studio. Verbinden Sie sich mit jener Microsoft SQL Instanz, welche die ADVOKAT Datenbanken beinhaltet.
...
- Abfrage von Terminduplikaten
| Wiki-Markup |
|---|
Mit dieser Abfrage können Sie prüfen, wie viele Terminduplikate existieren.
<ac:structured-macro ac:name="anchor" ac:schema-version="1" ac:macro-id="12dfa1fd-2571-4d9f-a623-6a05b73b0446"><ac:parameter ac:name="">OLE_LINK162</ac:parameter></ac:structured-macro><span style="color: #0000ff">USE</span> \[Advokat_DATEN\]
<span style="color: #0000ff">GO</span>
\\
<span style="color: #0000ff">SELECT</span> <span style="color: #808080">*</span> <span style="color: #0000ff">FROM</span> dbo<span style="color: #808080">.</span>Termin <span style="color: #0000ff">where</span> <span style="color: #ff00ff">concat</span><span style="color: #808080">(</span>ANr<span style="color: #808080">,</span> Datum<span style="color: #808080">,</span> Zeit<span style="color: #808080">,</span> Dauer<span style="color: #808080">,</span> Ende<span style="color: #808080">,</span> Sender<span style="color: #808080">,</span> SB<span style="color: #808080">,</span> Person<span style="color: #808080">,</span> Betreff<span style="color: #808080">,</span> Memo<span style="color: #808080">,</span> Art<span style="color: #808080">,</span> Erledigt<span style="color: #808080">,</span> Geschützt<span style="color: #808080">,</span> Flag<span style="color: #808080">,</span> Tag<span style="color: #808080">,</span> Pfad<span style="color: #808080">)</span> <span style="color: #808080">IN</span>
<span style="color: #808080">(</span><span style="color: #0000ff">SELECT</span> Wert <span style="color: #0000ff">FROM</span> <span style="color: #808080">(</span><span style="color: #0000ff">SELECT</span> Zähler<span style="color: #808080">,</span> <span style="color: #ff00ff">concat</span><span style="color: #808080">(</span>ANr<span style="color: #808080">,</span> Datum<span style="color: #808080">,</span> Zeit<span style="color: #808080">,</span> Dauer<span style="color: #808080">,</span> Ende<span style="color: #808080">,</span> Sender<span style="color: #808080">,</span> SB<span style="color: #808080">,</span> Person<span style="color: #808080">,</span> Betreff<span style="color: #808080">,</span> Memo<span style="color: #808080">,</span> Art<span style="color: #808080">,</span> Erledigt<span style="color: #808080">,</span> Geschützt<span style="color: #808080">,</span> Flag<span style="color: #808080">,</span> Tag<span style="color: #808080">,</span> Pfad<span style="color: #808080">)</span> <span style="color: #0000ff">AS</span> Wert <span style="color: #0000ff">FROM</span> dbo<span style="color: #808080">.</span>Termin<span style="color: #808080">)</span> <span style="color: #0000ff">AS</span> tmp
<span style="color: #0000ff">group</span> <span style="color: #0000ff">by</span> wert
<span style="color: #0000ff">having</span> <span style="color: #ff00ff">count</span><span style="color: #808080">(</span>Zähler<span style="color: #808080">)</span> <span style="color: #808080">></span> 1<span style="color: #808080">)</span>
<span style="color: #0000ff">order</span> <span style="color: #0000ff">by</span> Anr<span style="color: #808080">,</span> Datum<span style="color: #808080">,</span> Zeit
<span style="color: #0000ff">GO</span>
\\ |
- Löschung von Terminduplikaten
| Wiki-Markup |
|---|
Mit dieser Abfrage können Sie alle laut Schritt 3 gefundenen Terminduplikate löschen. Stellen Sie sicher, dass die Tabelle _dbo.TerminDuplikate_ nicht existiert, ist diese Tabelle vorhanden, muss sie vorher gelöscht werden.
<span style="color: #0000ff">USE</span> \[Advokat_DATEN\]
<span style="color: #0000ff">GO</span>
\\
<span style="color: #0000ff">SELECT</span> <span style="color: #808080">*</span> <span style="color: #0000ff">INTO</span> dbo<span style="color: #808080">.</span>TerminDuplikate <span style="color: #0000ff">FROM</span> dbo<span style="color: #808080">.</span>Termin <span style="color: #0000ff">WHERE</span>
<span style="color: #ff00ff">concat</span><span style="color: #808080">(</span>ANr<span style="color: #808080">,</span> Datum<span style="color: #808080">,</span> Zeit<span style="color: #808080">,</span> Dauer<span style="color: #808080">,</span> Ende<span style="color: #808080">,</span> Sender<span style="color: #808080">,</span> SB<span style="color: #808080">,</span> Person<span style="color: #808080">,</span> Betreff<span style="color: #808080">,</span> Memo<span style="color: #808080">,</span> Art<span style="color: #808080">,</span> Erledigt<span style="color: #808080">,</span> Geschützt<span style="color: #808080">,</span> Flag<span style="color: #808080">,</span> Tag<span style="color: #808080">,</span> Pfad<span style="color: #808080">)</span> <span style="color: #808080">in</span>
<span style="color: #808080">(</span><span style="color: #0000ff">SELECT</span> Wert <span style="color: #0000ff">FROM</span>
<span style="color: #808080">(</span><span style="color: #0000ff">SELECT</span> Zähler<span style="color: #808080">,</span> <span style="color: #ff00ff">concat</span><span style="color: #808080">(</span>ANr<span style="color: #808080">,</span> Datum<span style="color: #808080">,</span> Zeit<span style="color: #808080">,</span> Dauer<span style="color: #808080">,</span> Ende<span style="color: #808080">,</span> Sender<span style="color: #808080">,</span> SB<span style="color: #808080">,</span> Person<span style="color: #808080">,</span> Betreff<span style="color: #808080">,</span> Memo<span style="color: #808080">,</span> Art<span style="color: #808080">,</span> Erledigt<span style="color: #808080">,</span> Geschützt<span style="color: #808080">,</span> Flag<span style="color: #808080">,</span> Tag<span style="color: #808080">,</span> Pfad<span style="color: #808080">)</span> <span style="color: #0000ff">AS</span> Wert
<span style="color: #0000ff">FROM</span> dbo<span style="color: #808080">.</span>Termin<span style="color: #808080">)</span> <span style="color: #0000ff">AS</span> tmp
<span style="color: #0000ff">GROUP</span> <span style="color: #0000ff">BY</span> wert <span style="color: #0000ff">HAVING</span> <span style="color: #ff00ff">COUNT</span><span style="color: #808080">(</span>Zähler<span style="color: #808080">)</span> <span style="color: #808080">></span> 1<span style="color: #808080">)</span> <span style="color: #0000ff">ORDER</span> <span style="color: #0000ff">BY</span> anr<span style="color: #808080">,</span> datum<span style="color: #808080">,</span> zeit
<span style="color: #0000ff">GO</span>
\\
<span style="color: #0000ff">DELETE</span> <span style="color: #0000ff">FROM</span> dbo<span style="color: #808080">.</span>TerminDuplikate <span style="color: #0000ff">WHERE</span> Zähler <span style="color: #808080">IN</span>
<span style="color: #808080">(</span><span style="color: #0000ff">SELECT</span> Kleinster <span style="color: #0000ff">from</span> <span style="color: #808080">(</span><span style="color: #0000ff">select</span> <span style="color: #ff00ff">MIN</span><span style="color: #808080">(</span>Zähler<span style="color: #808080">)</span> <span style="color: #0000ff">AS</span> Kleinster<span style="color: #808080">,</span> Wert <span style="color: #0000ff">FROM</span>
<span style="color: #808080">(</span><span style="color: #0000ff">SELECT</span> Zähler<span style="color: #808080">,</span> <span style="color: #ff00ff">concat</span><span style="color: #808080">(</span>ANr<span style="color: #808080">,</span> Datum<span style="color: #808080">,</span> Zeit<span style="color: #808080">,</span> Dauer<span style="color: #808080">,</span> Ende<span style="color: #808080">,</span> Sender<span style="color: #808080">,</span> SB<span style="color: #808080">,</span> Person<span style="color: #808080">,</span> Betreff<span style="color: #808080">,</span> Memo<span style="color: #808080">,</span> Art<span style="color: #808080">,</span> Erledigt<span style="color: #808080">,</span> Geschützt<span style="color: #808080">,</span> Flag<span style="color: #808080">,</span> Tag<span style="color: #808080">,</span> Pfad<span style="color: #808080">)</span> <span style="color: #0000ff">AS</span> Wert <span style="color: #0000ff">FROM</span> dbo<span style="color: #808080">.</span>Termin<span style="color: #808080">)</span>
<span style="color: #0000ff">AS</span> tmp <span style="color: #0000ff">GROUP</span> <span style="color: #0000ff">BY</span> Wert <span style="color: #0000ff">HAVING</span> <span style="color: #ff00ff">COUNT</span><span style="color: #808080">(</span>Zähler<span style="color: #808080">)</span> <span style="color: #808080">></span> 1<span style="color: #808080">)</span> <span style="color: #0000ff">AS</span> tmp2<span style="color: #808080">)</span>
<span style="color: #0000ff">GO</span>
\\
<span style="color: #0000ff">DELETE</span> <span style="color: #0000ff">FROM</span> dbo<span style="color: #808080">.</span>Termin <span style="color: #0000ff">WHERE</span> Zähler <span style="color: #808080">IN</span>
<span style="color: #808080">(</span><span style="color: #0000ff">SELECT</span> Zähler <span style="color: #0000ff">FROM</span> dbo<span style="color: #808080">.</span>TerminDuplikate<span style="color: #808080">)</span>
<span style="color: #0000ff">GO</span>
\\
Nach Ausführung der Befehle löschen Sie die entstandene Tabelle _dbo.Terminduplikate{_}!
\\ |
- Aufgrund der Löschung in ADVOKAT wird die Löschung automatisch an Microsoft Exchange übertragen, die Terminduplikate müssen in Microsoft Office Outlook also nicht gelöscht werden.
...