From: jwilliam@aglresources.com   
      
   Thanks for the Reply!   
      
      
   Below is the output of the run   
      
   ====================================================   
   Start time=Feb 14 2013 11:08AM   
   ====================================================   
   Clean-up Processing Table= IF  EXISTS (SELECT * FROM sys.objects   
             WHERE object_id = OBJECT_ID('TEMP_BUS_DIR_NO_INSTMT_JAW') AND type   
   in ('U'))   
             BEGIN   
               DROP TABLE TEMP_BUS_DIR_NO_INSTMT_JAW END Time=Feb 14 2013 11:08AM   
   ====================================================   
    IF  EXISTS (SELECT * FROM sys.objects   
             WHERE object_id = OBJECT_ID('TEMP_BUS_DIR_NO_INSTMT_JAW') AND type   
   in ('U'))   
             BEGIN   
               DROP TABLE TEMP_BUS_DIR_NO_INSTMT_JAW END   
   ====================================================   
   Create Staging Table=TEMP_BUS_DIR_NO_INSTMT_JAW Time=Feb 14 2013 11:08AM   
   ====================================================   
   SELECT * INTO TEMP_BUS_DIR_NO_INSTMT_JAW FROM REP_BUS_DIR_NO_INSTMT_JAW WHERE   
   0=1   
   ====================================================   
   Fill Staging Table=TEMP_BUS_DIR_NO_INSTMT_JAW Time=Feb 14 2013 11:08AM   
   ====================================================   
   INSERT INTO TEMP_BUS_DIR_NO_INSTMT_JAW WITH (TABLOCK) SELECT * FROM   
   REP_BUS_DIR_NO_INSTMT_JAW   
   ====================================================   
   Rows Loaded to INSERT INTO TEMP_BUS_DIR_NO_INSTMT_JAW WITH (TABLOCK) SELECT *   
   FROM REP_BUS_DIR_NO_INSTMT_JAW = 5000   
   ====================================================   
   TRUNCATE REP Table=REP_BUS_DIR_NO_INSTMT_JAW Time=Feb 14 2013 11:08AM   
   ====================================================   
   TRUNCATE TABLE REP_BUS_DIR_NO_INSTMT_JAW   
   ====================================================   
   Fill REP Table=REP_BUS_DIR_NO_INSTMT_JAW Time=Feb 14 2013 11:08AM   
   ====================================================   
   INSERT INTO REP_BUS_DIR_NO_INSTMT_JAW WITH (TABLOCK) SELECT * FROM   
   TEMP_BUS_DIR_NO_INSTMT_JAW WHERE KY_BA IN (SELECT KY_BA  FROM  [   
   ISStagingDB].[dbo].[REP_BILL_ACCT] (nolock) WHERE  CD_OFFICE > '079'   
   ====================================================   
   Msg 50000, Level 16, State 1, Procedure usp_Purge, Line 144   
   Incorrect syntax near '079'   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)