Jump to content

Recommended Posts

Posted

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)

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...