Stamms (author)
Author, followers, and translators associated with this PostIt.
| Thumbnail | Username | Role | Balance | Deadline | Emailed | Closed | |
|---|---|---|---|---|---|---|---|
|
KAT Author | kathrin@nulllogic.de | Author | $3.00 | - | Yes | Yes |
|
Datenbank Co. | DatenbankCo@oli-it.com | Responder | $5.00 | - | Yes | Yes |
|
Frederic Luchting | Frederic.Luchting@NullLogic.de | Responder | $4.00 | 2003-08-25 | Yes | Yes |
Codes (Descriptions)
| Comment | Status | Scanned | Receivers | |
|---|---|---|---|---|
| Code von KAT | - | Yes | 2 | view |
Angler (Matching)
| Angler | Status | Matched Time | Read Time | |
|---|---|---|---|---|
| SQL Server | - | 2003-08-08 02:02 | - | view |
| Access | ok 07.08.2003 20:58:06 | 2003-08-01 16:30 | - | view |
TopLabs (Answers)
| Thumbnail | TopLab | Author | Date | Reward |
|---|---|---|---|---|
| -- begining of query that you need declare @count int declare @call_code int declare tmpcursor cursor for select call_code, count(*) from ##cah group by call_code having COUNT(*) > 1 open tmpcursor fetch next from tmpcursor into @call_code, @count while @@fetch_status = 0 begin set @count = @count - 1 set rowcount @count delete from ##cah where call_code = @call_code fetch next from tmpcursor into @call_code, @count end close tmpcursor deallocate tmpcursor go -- end of query | Frederic Luchting | 2002-07-16 | $13.53 |