Posted in asp.net 2, c# on September 26, 2008 | 2 Comments »
hi all, i have facing problem while Executing Insert query with dataTime on Oracle database. This query is generated by string manuplation using C# at business layer . i fix the date time as in Query
“TO_DATE(‘” + ProdMonitor.TRANSACTIONDATE.Month+
“/” + ProdMonitor.TRANSACTIONDATE.Day +
“/” + ProdMonitor.TRANSACTIONDATE.Year+
” ” + ProdMonitor.TRANSACTIONDATE.ToLongTimeString()+
“‘,’mm/dd/yyyy HH:MI:SS PM’),”
The Whole Query Will be like
Insert [...]
Posted in jokes on September 20, 2008 | Leave a Comment »
picture worth thousand words check this out
Posted in songs on September 20, 2008 | 12 Comments »
Pekar meaning picture
i was surpise to listen this farsi song from pakistani singer, but wordings are beautiful with out standing voice
lyrics are as follow
Pekar-e-Husn-o-jamal-o-khud numai yak taraf
Jaan bay deegar duroon-e-aQL shakl-e-badnuma
Khwab deedan yak taraf tabeer deedan yak taraf
Sazish-o-makr-o-farebi, zarf khoordan gumzada
Haif insaan Haif insaan Shehr-e-mann herat kada
Too hidayat yak [...]
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 [...]
