BeerBond007 Posted January 5, 2016 Report Posted January 5, 2016 State deductible new column FL. 0. FULL FL. 300. 300 FL. 0. FULL FL. 0. FULL AL. 0. 0 AL. 0. 0 AL. 0. 0 GA. 200. 200 GA. 200. 200 GA. 0. 0 Requirement Needs to create new column and populate FULL for zeros for Florida state ..(only for Florida state ) .. Help help help
creativity Posted January 5, 2016 Report Posted January 5, 2016 Update tablename set columnname=full where state=fl and deductible=0...
BeerBond007 Posted January 5, 2016 Author Report Posted January 5, 2016 Update tablename set columnname=full where state=fl and deductible=0... Update aaa luv da na .... Case statement seppu ra ayya
BeerBond007 Posted January 5, 2016 Author Report Posted January 5, 2016 Update tablename set columnname=full where state=fl and deductible=0... Straight and out straight kaadu ra ayya .... I have some 6 tables to join to get this data ... Select statement lo oka column ki case raayali aka cepou ... Naku vachindi kuda donbettu unav ga nee creativity tho
CheGuevara Posted January 5, 2016 Report Posted January 5, 2016 State deductible new column FL. 0. FULL FL. 300. 300 FL. 0. FULL FL. 0. FULL AL. 0. 0 AL. 0. 0 AL. 0. 0 GA. 200. 200 GA. 200. 200 GA. 0. 0 Requirement Needs to create new column and populate FULL for zeros for Florida state ..(only for Florida state ) .. Help help help Already full ani undi kada Florida state ki zero deductible unna place lo Nuvvu vesina table data after the update or is it thats tge way the data is and u need to do the same for remaining Florida state rows Nee req ardamkale ... Ela undi data ela kavali ani clear ga veyyi
creativity Posted January 5, 2016 Report Posted January 5, 2016 Update aaa luv da na .... Case statement seppu ra ayya Select state,deductible,case when state =fl and deductible =0 then 'full' else 'loveda' end as newcolumn from tablename...
BeerBond007 Posted January 5, 2016 Author Report Posted January 5, 2016 Already full ani undi kada Florida state ki zero deductible unna place lo Nuvvu vesina table data after the update or is it thats tge way the data is and u need to do the same for remaining Florida state rows Nee req ardamkale ... Ela undi data ela kavali ani clear ga veyyi Full ani Nen raasa bro ... Paina new column ani andke petta ga... Adi.. New column lo data naa requirement ...
BeerBond007 Posted January 5, 2016 Author Report Posted January 5, 2016 Select state,deductible,case when state =fl and deductible =0 then 'full' else 'loveda' end as newcolumn from tablename... Ninu thittalani undi bro baaga ... Amma na bhoothulu... Nee pellani ni ... Ani thittalani undi ...forget it ... Thanks
creativity Posted January 5, 2016 Report Posted January 5, 2016 Ninu thittalani undi bro baaga ... Amma na bhoothulu... Nee pellani ni ... Ani thittalani undi ...forget it ... Thanks
CheGuevara Posted January 5, 2016 Report Posted January 5, 2016 Full ani Nen raasa bro ... Paina new column ani andke petta ga... Adi.. New column lo data naa requirement ... Mari inkenti meeda creativity cheppina update statement work avthadi kada.... Aa uodate query new column ni full ga set chestundi ekkadite state Florida and deductible zero undo... Neeku ala kakunda inka vere rakangha kavala query.??
babugaru Posted January 5, 2016 Report Posted January 5, 2016 State deductible new column FL. 0. FULL FL. 300. 300 FL. 0. FULL FL. 0. FULL AL. 0. 0 AL. 0. 0 AL. 0. 0 GA. 200. 200 GA. 200. 200 GA. 0. 0 Requirement Needs to create new column and populate FULL for zeros for Florida state ..(only for Florida state ) .. Help help help First column create cheyyi ,tarvatha aan 6 tables or entha unteanni kalipi cursor raayi , loop tippu update kottu
BeerBond007 Posted January 5, 2016 Author Report Posted January 5, 2016 First column create cheyyi ,tarvatha aan 6 tables or entha unteanni kalipi cursor raayi , loop tippu update kottu Forget it bro ... Question sariga explain cheila.... It doesn't look that simple the way you guys are telling.. I will try myself .. Again thanks
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts