Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: FerozShaik
- Order by date
-
validate records that are >= 6 months apart
This is the help that i got from Dieter. works good. CREATE VOLATILE TABLE vt AS ( SELECT customerid, entrytimestamp, ROW_NUMBER() OVER (PARTITION BY customerid ORDER BY entrytimestamp) AS rn FROM feroz ) WITH DATA PRIMARY INDEX (customerid, rn) ON COMMIT PRESERVE ROWS ...- FerozShaik
- Post #2
- Forum: NCR: Teradata
-
validate records that are >= 6 months apart
I have a table that has customerid, and entrytimestamp. (combination of customerid and entrytimestamp is unique). I am trying to mark some records in this table with valid_ind = 1. The first time a customer record is enterd in the table it can be marked as Valid. A customer can be marked valid...- FerozShaik
- Thread
- Replies: 1
- Forum: NCR: Teradata
