• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Sql statement

 
shumani edzani
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All..

I have been struggling with this code for 3 hours now,can you please help.this code is hard coded and i need to unhard code it,so here is the code please help.

select staticdata.descr as deptname,appraisal.state as appraisalPhase,appraisal.lastupdated,appraisal.scoreunitid
from appraisal
left JOIN hruser on hruser.userid = appraisal.appraisee
LEFT JOIN staticdata on staticdata.id = hruser.deptname
where appraisal.lastupdated > "1999/01/01"
AND appraisal.lastupdated < "2009/01/01"
and appraisal.state in ("SUBMITTED", "CREATED_INCOMPLETE", "UPDATED_UNCONFIRMED", "COMPLETE_UNCONFIRMED"
, "DEV_PLAN_SET")
AND staticdata.id in ("1179991863437762177185","123539977081431915490412353998213101873543512353999380021949703600")
group by hruser.deptname

Thank you.
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by "un-hardcode" it? What are you trying to do with this query?
 
denis sorn
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I presume he wants to be able to change parameters dynamically...

If this is what you want Shumani you can do it with PreparedStatement.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic