sql help neede love india

[vizagpower]

;With ResetImageGenFlag_CTE AS
(
SELECT 
ua.ind_no,
a.individual_id,
a.id,a.ff_id,
a.dateEnd,
ua.imagegen_dt,
DATEDIFF(SS,(dateEnd),ua.imagegen_dt) as TimeElapse,
ua.imagegen_flag,
CASE  WHEN DATEDIFF(SS,a.dateEnd,ua.imagegen_dt) <=120 then 0 else ua.imagegen_flag end as [Flag],
ROW_NUMBER() Over(Partition By individual_id Order By [dateEnd] DESC) Rnk
FROM uaimage ua  
INNER JOIN 
( SELECT ff.individual_id,frr.* 
 FROM  uas.fileread_reads frr
INNER JOIN uas.fileread_files ff on frr.ff_id=ff.id
WHERE ff.id in (SELECT id FROM uas.fileread_files WHERE lu_semester=48) and dateEnd is not null ) a ON a.individual_id= ua.ind_no  and ua.doctype = 'RDST'
)

 

---Select *  From  ResetImageGenFlag_CTE Where  Rnk =1 

Select * Into #Imagegen_Temp From  ResetImageGenFlag_CTE  --- File reads with Max DateEND
  Where  Rnk =1

drop table #Imagegen_Temp

SELECT T.individual_id
      ,A.[ind_no]
      ,A.[imagegen_flag],t.dateEnd
      ,A.[imagegen_dt]
      ,datediff(SS,T.dateEnd,A.imagegen_dt)as TimeElapsed
  FROM [UAImage] A INNER JOIN  #Imagegen_Temp T On T.individual_id = A.ind_no
  where A.doctype = 'RDST' 

--- updates the imagegenflag---
Update X
  Set x.[imagegen_flag] = (CASE WHEN  datediff(SS,T.dateEnd,X.imagegen_dt) <= 120 Then 0 Else x.[imagegen_flag]End)
  From [UAImage] X   
  INNER JOIN  #Imagegen_Temp T On T.individual_id = X.ind_no
  WHERE X.doctype = 'RDST'

DROP TABLE #Imagegen_Temp;

ee drop not working any idea ???

[Spon]

@loveindia meeyy 

[vizagpower]

Just now, Spon said:

@loveindia meeyy 

enti idi ????

[loveindia]

two time drop statements pettav endi man???

[vizagpower]

Just now, loveindia said:

two time drop statements pettav endi man???

shall i remove the last one , typed the highlighted in overlook 

[loveindia]

Just now, vizagpower said:

shall i remove the last one , typed the highlighted in overlook 

no man, remove the one in red... you are creating the temp then immediately you are dropping it... how come will you be able to JOIN in the below update man...? 

one more question... are you running these two queries in same proc or different ones man?

[loveindia]

4 minutes ago, Spon said:

@loveindia meeyy 

ee spoon evvad man... 

[vizagpower]

Just now, loveindia said:

no man, remove the one in red... you are creating the temp then immediately you are dropping it... how come will you be able to JOIN in the below update man...? 

one more question... are you running these two queries in same proc or different ones man?

same proc , any problem dude

 

 

[Spon]

Just now, loveindia said:

ee spoon evvad man... 

It's Single "o" meeyy 

[vizagpower]

Just now, Spon said:

It's Single "o" meeyy 

laadu lodi meeyy enti raaa spoooonuuuuuuuuuuu

[loveindia]

1 minute ago, vizagpower said:

same proc , any problem dude

 

 

no man, just checking... just remove the red DROP TABLE command thats it man....

[vizagpower]

Just now, loveindia said:

no man, just checking... just remove the red DROP TABLE command thats it man....

will try anna , thanks as ever 

[Spon]

Just now, vizagpower said:

laadu lodi meeyy enti raaa spoooonuuuuuuuuuuu

It's single "o" meyy, I am SPON 

[vizagpower]

Just now, Spon said:

It's single "o" meyy, I am SPON 

pakaki dennnnnnnnnnn

[loveindia]

1 minute ago, vizagpower said:

will try anna , thanks as ever 

np buddodi fan man....