Syntax error

• yaip

  SSCrazy

  Points: 2656

  More actions

  February 12, 2005 at 9:32 pm

  #85081

  I am trying the following statement:

  insert into tblStudent_Sponsor(intStudentID, intSponsorID)

  values

  select distinct studentid,sponsorid

  from tblContractRates

  and I am getting:

  Server: Msg 156, Level 15, State 1, Line 3

  Incorrect syntax near the keyword 'select'.

  I am sure this is a brain-freeze

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  February 12, 2005 at 10:27 pm

  #541949

  insert into tblStudent_Sponsor(intStudentID, intSponsorID)

  select distinct studentid,sponsorid

  from tblContractRates

  remove values, for futher details refer the BOL

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/