InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 22:08:03 GMT20http://www.sqlservercentral.com/Forums/Topic1281374-324-1.aspx[url=http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx]http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx[/url]For details about posting ddl and sample data see the first link in my signature.Wed, 11 Apr 2012 08:07:55 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1281374-324-1.aspxCan you supply DDL tables and respresentative data, search this forum for how to request help and i will have a look at what you askWed, 11 Apr 2012 05:01:03 GMTSGT_squeequalhttp://www.sqlservercentral.com/Forums/Topic1281374-324-1.aspxThere is only one database.I have got 1 table with the fields qid,qans.One more table with the fields qid,uans,result.I want to compare each record of qans and uans and if they match then answer should be 1 and it should store value 1 in result respective row.If it does'n match then it should store value 0 in the result field of respective row.How to write this code and where?Wed, 11 Apr 2012 02:22:43 GMTsolvedpaer