Home Forums SQL Server 2008 T-SQL (SS2K8) How to run a view every 1000 rows to add in table? RE: How to run a view every 1000 rows to add in table?

  • November 30, 2015 at 4:41 pm

    #1843060

    Jeff,

    There is enough information for one suggestion:

    WHERE CAL.Date<=GETDATE()

    AND CAL.DATE>='20150101'

    Even for two:

    Clustered index on CAL.Date

    🙂

    _____________
    Code for TallyGenerator