sql help

[vizagpower]

im trying to update a table based on the below logic , 

but its failing , any idea where im going wrong ??

 

UPDATE  uaimage_test
SET    imagegen_flag = ( CASE
                 WHEN datediff(SS,frr.dateEnd,ua.imagegen_dt) <= 120 THEN 0
                 ELSE 1
               END )
FROM   uas.fileread_files ff 
inner join uaimage_test ua  on ff.individual_id=ua.ind_no
inner join uas.fileread_reads frr on frr.ff_id=ff.id   
where  docType='RDST' and frr.dateEnd is not null 
and ff.id in ( select id from uas.fileread_files where lu_semester=48)

[SlMHAM]

Sharma ni pilichi o soda kottivvamanu chebuta 

[vizagpower]

1 minute ago, SlMHAM said:

Sharma ni pilichi o soda kottivvamanu chebuta 

baa whats ur old id , pm me 

[VCR]

2 minutes ago, vizagpower said:

im trying to update a table based on the below logic , 

but its failing , any idea where im going wrong ??

 

UPDATE  uaimage_test
SET    imagegen_flag = ( CASE
                 WHEN datediff(SS,frr.dateEnd,ua.imagegen_dt) <= 120 THEN 0
                 ELSE 1
               END )
FROM   uas.fileread_files ff 
inner join uaimage_test ua  on ff.individual_id=ua.ind_no
inner join uas.fileread_reads frr on frr.ff_id=ff.id   
where  docType='RDST' and frr.dateEnd is not null 
and ff.id in ( select id from uas.fileread_files where lu_semester=48)

error em osthondi ?

[vizagpower]

Just now, VCR said:

error em osthondi ?

error ravatledu , but not updating the way i wanted 

[SlMHAM]

3 minutes ago, vizagpower said:

im trying to update a table based on the below logic , 

but its failing , any idea where im going wrong ??

 

UPDATE  uaimage_test
SET    imagegen_flag = ( CASE
                 WHEN datediff(SS,frr.dateEnd,ua.imagegen_dt) <= 120 THEN 0
                 ELSE 1
               END )
FROM   uas.fileread_files ff 
inner join uaimage_test ua  on ff.individual_id=ua.ind_no
inner join uas.fileread_reads frr on frr.ff_id=ff.id   
where  docType='RDST' and frr.dateEnd is not null 
and ff.id in ( select id from uas.fileread_files where lu_semester=48)

idhi pani chestadantava??

[vizagpower]

2 minutes ago, SlMHAM said:

idhi pani chestadantava??

i mean if  , if duration less than 120 sec , i need to reset it to 0, am i missing something ??? just checked , case is working fine

 

[SlMHAM]

Just now, vizagpower said:

i mean if  , if duration less than 120 sec , i need to reset it to 0, am i missing something ???

 

asalu failure error endho post cheste janalaki easy avutundi ekkada dobbutondo ani 

[VCR]

4 minutes ago, vizagpower said:

error ravatledu , but not updating the way i wanted 

first aa case statement run chesi chudu work aithunnada ?

[vizagpower]

1 minute ago, VCR said:

first aa case statement run chesi chudu work aithunnada ?

yes ,its fine

[4Vikram]

6 minutes ago, SlMHAM said:

asalu failure error endho post cheste janalaki easy avutundi ekkada dobbutondo ani 

fail aitaledu update aitaledu antundu kada

[VCR]

Just now, 4Vikram said:

fail aitaledu update aitaledu antundu kada

akkada select run aithunnadi antunnadu malla update kakpovadam endi same case statement tho 

[SlMHAM]

5 minutes ago, vizagpower said:

yes ,its fine

 

3 minutes ago, 4Vikram said:

fail aitaledu update aitaledu antundu kada

 

2 minutes ago, VCR said:

akkada select run aithunnadi antunnadu malla update kakpovadam endi same case statement tho 

sare neeku maaku sync avatle gani..

Single update badulu randu rayi... case statement badulu where use cheyyi...

 

oka update statement with flag = 0 when datediff <=120

inkoti update statement with flag = 1 when datediff >120

7 minutes ago, vizagpower said:

yes ,its fine

Select CASE
                 WHEN datediff(SS,frr.dateEnd,ua.imagegen_dt) <= 120 THEN 0
                 ELSE 1
               END  AS test
FROM   uas.fileread_files ff 
inner join uaimage_test ua  on ff.individual_id=ua.ind_no
inner join uas.fileread_reads frr on frr.ff_id=ff.id   
where  docType='RDST' and frr.dateEnd is not null 
and ff.id in ( select id from uas.fileread_files where lu_semester=48)

Run cheyyi emustundo cheppu

[4Vikram]

26 minutes ago, VCR said:

akkada select run aithunnadi antunnadu malla update kakpovadam endi same case statement tho 

yeah nenu kuda chusna run aindi bane mari update enduku avaledu oo no idea

 

[SlMHAM]

Sharma yaadapoyav