Sub Account Day begin error and Solution

Sub Account Run-time error '-2147467259 (80004005)'

Sub Query returned more than 1 value. This is not permitted when the subquery follows =, !=, <, 123

• Download the attached file sub query problem in bo sub Accounts.zip. On unzipping , u will get two files viz..Delete Duplicate Records.sql and BOSUBACCOUNTS08102009.exl. 
• First execute the file BOSUBACCOUNTS08102009.exl using script tool. 
• Thereafter open the file Delete Duplicate Records.sql using notepad and change the date as last working day for today's day begin. Then execute the query using query analyzer.

Download