sql experts please come

[4Vikram]

14 minutes ago, JollyBoy said:

yes.. sarigga cheyak pote tholu teestadi.. my manager oncch up on a tym 

tyalented vundi vunty inpact multy tyalented undi 

9 minutes ago, Bangaruu said:

Miss u da vaishu

[Bangaruu]

6 minutes ago, 4Vikram said:

tyalented vundi vunty inpact multy tyalented undi 

[riashli]

52 minutes ago, shamsher_007 said:

y hitting re @riashli

Oorike

[riashli]

53 minutes ago, 4Vikram said:

vunty laang tame no see how you?

Bagunna vikky 

[Bangaruu]

[fake_Bezawada]

11 hours ago, 4Vikram said:

i have a requirement like this..

Select AB, AC, AD, AE FROM Tbl.ABC 

Aite AD lo values are like Alabama, Alaska, Arkansas and so on..

I need to create a view which gets me results like 

IF AD = Alabama then 1 if AD = Alaska then 2 atla continuation and this will be like an added new column AF anukondi.. suggestions please and thanks

case statement vundhi ga adhi vaduko bro

[fake_Bezawada]

1 hour ago, 4Vikram said:

vunty laang tame no see how you?

twins akkada busy kaka inkem vuntadi

[former]

Instead of CASE use DECODE 

Decode function like mapping.

Or else create mapping table Join back to main table.

[4Vikram]

7 hours ago, fake_Bezawada said:

twins akkada busy kaka inkem vuntadi

correst man 

[solman]

@4Vikram uncle case statement anta use cheyyi... 

[4Vikram]

15 hours ago, JollyBoy said:

 

;with SS  as

(select 
      ,A.[STRING_VALUE1],STATE_ID
          , ROW_NUMBER() over (partition by A.[STRING_VALUE1] order by A.[STRING_VALUE1])  RN 
FROM [tbl_APP_DROPDOWN_VALUES] ) 

UPDATE  T SET T.STATE_ID = S.RN FROM [tbl_APP_DROPDOWN_VALUES] T inner join  SS S on S.[STRING_VALUE1] = T.[STRING_VALUE1]

bhaiyyya STATE_ID ane column ledu i am retrieving it as a result column.. the query not working

[4Vikram]

4 minutes ago, solman said:

@4Vikram uncle case statement anta use cheyyi... 

already camed man, ninane solve aindi matter but chaala mandhi helped no.. thanks 

[JollyBoy]

Just now, 4Vikram said:

bhaiyyya STATE_ID ane column ledu i am retrieving it as a result column.. the query not working

okasari copy paste chesi run chey above query 

[JollyBoy]

2 minutes ago, 4Vikram said:

bhaiyyya STATE_ID ane column ledu i am retrieving it as a result column.. the query not working

STATE_ID  already table lo unda.. leka create cheyala 

[4Vikram]

25 minutes ago, JollyBoy said:

STATE_ID  already table lo unda.. leka create cheyala 

create cheyale table lo ledu.. its like new column for result set anthe