problem with an insert statement

• winston Smith

  SSCoach

  Points: 19500

  More actions

  May 23, 2006 at 2:57 am

  #115214

  im having a problem with an insert statement. the problem is that the program column is left null even after the query is ran.

  insert into NewReport(program)

  select p.description from program p left join newReport nr on p.programID = nr.programID

  where p.programId = nr.programId

  i can run the sub query and that returns all the data, but when i put the insert into part over it, i am told that all the rows have been affected, but there are no changes to them. they still contain NULL. the datatypes are the same so thats not the problem. any ideas?

• Ajit-297150

  Mr or Mrs. 500

  Points: 593

  More actions

  May 23, 2006 at 3:12 am

  #639436

  I Think you want to update the Description [NewReport] from the Progarm master where a matcing ProgramId is matched.

  Update NewReport

  set program =  p.description

  from program p inner join newReport nr on p.programID = nr.programID

  Hope it helps...