The multi-part identifier "getmaxfid.maxfid" could not be bound.

• lithcause

  Valued Member

  Points: 62

  More actions

  August 21, 2008 at 2:27 pm

  #192667

  Select MAX(FID) as maxfid

  from FarmInfo

  SELECT FID, Etc, Mtc, Tur, wegb, ost, other, Pmtc, Ctel, Cmtc, Cmtt, Supplemental

  FROM FarmInfo

  where (FID = getmaxfid.maxfid)

  INSERT INTO SubpartDataId

  (subpartid

  ,FID)

  VALUES

  ('#1#'

  ,'#FID#')

  where FID = getmaxfid.maxfid

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  August 21, 2008 at 2:37 pm

  #861542

  Do not see a question....

  Please read the article whose link is in my signature block and then re-post

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]