sql help

[vizagpower]

36 minutes ago, SlMHAM said:

 

 

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

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

aa case statement working but the freaking u

 

5 minutes ago, SlMHAM said:

Sharma yaadapoyav

im here simhaaa