Home Forums SQL Server 2005 SQL Server 2005 General Discussion Data Warehouse Update to Live Table RE: Data Warehouse Update to Live Table

  • October 9, 2013 at 10:15 am

    #1657227

    Can you try

    DELETE FROM fact.WorkOrder WHERE CreateDate >= @startdate OPTION (RECOMPILE)

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]