TopLab:

TopLabGuid
29872cf1-bff2-48d6-a6b0-cc297ca01858
Date
7/16/2002 11:20 PM
Description
No Beschreibung??????????????
Type
txt

JSON Response

{
  "topLabGuid": "29872cf1-bff2-48d6-a6b0-cc297ca01858",
  "stammGuid": "1951cc74-e2b6-4523-a336-d52a5dd6908c",
  "postItGuid": "f574a374-1f83-4cfe-9a82-0587f8cbf650",
  "titel": null,
  "topLab1": "-- begining of query that you need\r\ndeclare @count int\r\ndeclare @call_code int\r\ndeclare tmpcursor cursor\r\nfor\r\nselect\r\ncall_code, count(*)\r\nfrom\r\n##cah\r\ngroup by\r\ncall_code\r\nhaving\r\nCOUNT(*) \u003E 1\r\nopen tmpcursor\r\nfetch next from tmpcursor into @call_code, @count\r\nwhile @@fetch_status = 0\r\nbegin\r\n\u00A0 set @count = @count - 1\r\n\u00A0 set rowcount @count\r\n\u00A0 delete from ##cah where call_code = @call_code\r\n\u00A0 fetch next from tmpcursor into @call_code, @count\r\nend\r\nclose tmpcursor\r\ndeallocate tmpcursor\r\ngo\r\n-- end of query",
  "url": "http://www.berndjungbluth.de/sqlfaq/sqlfaq.htm",
  "lohn": 13.5300,
  "datum": "2002-07-16T23:20:28.107",
  "datei": "",
  "topTopLabGuid": null,
  "typ": "txt",
  "inboxes": [],
  "inverseTopTopLab": [],
  "postIt": null,
  "stamm": null,
  "tollis": [],
  "topTopLab": null
}