| # | Date | Forum | Type | Thread | Post |
|---|
| 2 | 16 Dec 2010 @ 02:17 PST | Database | Reply | Teradata IDENTITY columns | Hi All, I have my identity column in negative (as stated above). When I try to insert a record, it goes to number lesser than minimum limit..
ID_NUM BIGINT NOT NULL GENERATED BY DEFAULT AS IDE... |
| 1 | 07 Jun 2010 @ 11:58 PDT | Database | Reply | teradata sql help | This works as well...
update t1
from
table1 t1,
(
sel
c1,
c2,
c3,
c4,
t1.c5,
d1,
d2,
case
when c3 > d1 and c4 < d2 and c2 = 'Y' then 'Y'
when c3 > d1 and c4 < d2 and c2 = 'N' t... |
|
|