Got more questions? Find advice on: SQL | XML | Regular Expressions | Windows
in Search
Welcome to AspAdvice Sign in | Join | Help

Browse by Tags

All Tags » sql » Tips
Sorry, but there are no more tags available to filter with.
  • Using a Numbers Table to Iterate Over Dates

    I recently wrote some SQL which would do some work for a single day, but I wanted my code to be able to run once for each day in a date range. Luckily for me, I read Gregg Stark's SQL Blog. He recently posted about how to Iterate Over a List of Dates using a Numbers table in SQL. The SQL he gives is pretty much a cookie cutter solution to the ...
    Posted to Orcs Goblins and .NET (Weblog) by Brendan on October 10, 2007