Home Forums SQL Server 2005 T-SQL (SS2K5) Splitting Data by day RE: Splitting Data by day

  • November 14, 2012 at 8:28 am

    #1558965

    Jeff Moden (11/14/2012)

    Just as a follow up to what Eugenne posted...

    If you'd like to know more about how a Tally Table works and how it can be used as a high performance replacemment for many types of things that loop, please see the following article.

    http://www.sqlservercentral.com/articles/T-SQL/62867/

    Just to add my point again, coming with strong non-SQL programming background, I usually start my Tally from 0, as I prefer 0-based arrays over 1-based ones... :hehe:

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]