Updation Query

• vs.satheesh

  SSCrazy

  Points: 2392

  More actions

  May 13, 2016 at 12:25 am

  #104325

  Hi

  I am handling university Project . I have following scenario.

  Table Format

  ASID , LOV,EvaluatorID

  AS1 1null

  AS1 2null

  AS2 1Null

  AS2 2Null

  AS3 1Null

  AS3 2Null

  AS4 1Null

  AS4 2Null

  AS5 1Null

  AS5 2Null

  .

  .

  .

  AS100

  In this above table structure,Each Answer script published two level of evaluation .

  my requirement any elevator use my module allocate the answer script themselves. i want update in following methods. For example Evaluator1 want 5 answer script means updation in following manner(same

  elevator should not evaluate both the level of answer scripts).

  ASID , LOVEvaluator ID

  AS1 1Evaluator1

  AS2 1Evaluator1

  AS3 1Evaluator1

  AS4 1Evaluator1

  AS5 1Evaluator1

  Evaluator 2 in following methods

  ASID , LOVEvaluator ID

  AS1 2Evaluator2

  AS2 2 Evaluator2

  AS3 2Evaluator2

  AS4 2Evaluator2

  AS5 2Evaluator2

  Evaluator 3 in following methods

  ASID, LOV,Evaluator ID

  AS6 1Evaluator3

  AS7 1 Evaluator3

  AS8 1Evaluator3

  AS9 1Evaluator3

  AS10 1Evaluator3

  Please help me above result.i want Update Query?