What it means is that the row size for the table has exceeded 8060 which is the max allowed and if u insert/update a rec which exceeds this size the...

Ok i see what ur trying to do ...tblTMPFileLoad is a temp storage place from which u insert into tblCustomer and now u need the id to insert into tblAddlInfo

if...

Do you want to delete duplicate records from the table ?? if yes then whats the table structure

Hi,

U can get a list of packages that match the customers option by using this sql

SELECT Pkg.Pkg

FROM

(SELECT Pkg As Pkg,

COUNT(*) As OptMatch

FROM PkgOptions

INNER JOIN CustOptions

ON CustOptions.Opt =...