Re: Delete Only 50 rows from table

Obnoxio The Chav said: > > Serge Rielau said: > >> So hwo do you implement queue and to-do style data? >> What about an "outstanding orders" table? >> A staging table in a warehouse? >> Oustanding tickets in a support center? > > Fuck me gently, Serge, I hope that's a joke? Outstanding orders table? Working on the premise that Germans don't have a sense of humour, and Canadian Germans doubly so: 1. With a status flag. This has the added bonus of being able to re-route things or restart a process. If you delete the data, then how can you do this? 2. You have an orders table. Outstanding orders get a different status flag. 3. I'm not too sure why a warehouse staging table wouldn't be processed in full and then truncated, 4. See 1. And 2. PS -- Only kidding about Germans and senses of humour. Just look at Kraftwerk. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg sending to informix-list