&nbsp;<BR>I have a table with 2 columns.<BR>and i have dictionary object with same 2 columns.<BR><BR>I am reading dicionary items and i want to update the table <BR>if the column with that value is existing or else i want to add new record<BR>what is optimum method to do this.<BR><BR>my code is like this.<BR><BR>cnnconnection.begintrans<BR>set tempstats = session("clickevents") &#039dictionary object<BR>tempitems = tempstats.items<BR>tempkeys = tempstats.keys<BR><BR>orssql1 = "select * from today_page_hits"<BR>set orssql=cnnconnection.execute orssql1<BR><BR>for i = 0 to ubound(tempkeys)<BR>count = tempitems(i)<BR>pagename = tempkeys(i)<BR><BR><BR> orssql.find "pagename = &#039"&pagename&"&#039,0,adsearchforward<BR> if orssql.eof then<BR> orssql.addnew<BR> orssql("page_name") = pagename<BR> orssql("no_of_hits") = count <BR> else<BR> orssql("no_of_hits") = count + orssql("no_of_hits")<BR> end if<BR> orssql.movefirst<BR><BR>Next<BR>orssql.updatebatch %&#062;<BR>cnnconnection.committrans