Posted in teradata, teradata SQL, teradata WareHouse on September 16, 2008 | 2 Comments »
hi all, i use following syntex for this
UPDATE T1 FROM (SELECT t2_1, MIN(t2_2) from T2 group by 1) as D (D1, D2)
SET Field2 = D2
WHERE Field1 = D1
So i solve my problem as
UPDATE XTZ.KPI FROM (SELECT CONVERTED_TARGET_QTY,NORMAL_VALUE,CRITICAL_VALUE FROM DP_UTL.PRODUCTION_KPI WHERE PACKAGE=’SSPET-500′) AS D(D1,D2,D3) SET
MaximumValue = D1
, NormalValue = D2
, CriticalValue [...]
Posted in teradata, teradata SQL, tagged teradata, teradata SQL on September 13, 2008 | Leave a Comment »
While working on teradata we have to show some reports on database, for example MTD month to date, YTD year to date, While searching Records on The bases of YTD , I have to Find records till start of last month and till today. The I have to create first date of last years as [...]
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Sep | ||||||
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | ||||||
