[SQL] need help

2007-05-13 Thread Penchalaiah P.
Hi ... Create table cdano_nya(cdano int4,nyano int4) ... I created this table and then I inserted some values to this( 234576,86)... Now when I am updating this table .. its not updating ..query is continuously running... When I am stopping query its

Re: [SQL] table juxtaposition

2007-05-13 Thread Rodrigo De León
On May 1, 10:47 pm, [EMAIL PROTECTED] wrote: > Hello all, > I have a table with 2 issues, issue_A and issue_B, a table with action > items related to the issues, > > issue_A AI_A1 > issue_A AI_A2 > issue_A AI_A3 > issue_B AI_B1 > issue_B AI_B2 > > and network elements that the issues affect: > > is

Re: [SQL] Funny date-sorting task

2007-05-13 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > Every task has a timestamp X that may be NULL or a date. > ... > Sometimes it has date and the time-part, too. > > The list should be like this: > 1) X sometime today should come first in ascending time order. > 2) X in the past shoul

Re: [SQL] Funny date-sorting task

2007-05-13 Thread Rodrigo De León
On 5/12/07, Frank Bax <[EMAIL PROTECTED]> wrote: At 07:40 PM 5/12/07, Andreas wrote: >I've got a stack of tasks to show in a list. >Every task has a timestamp X that may be NULL or a date. It contains the >date when this tasks should be done. >Sometimes it has date and the time-part, too. > > >