I've used Visual Studio (2010 Ultimate) with SVN via Ankh and it's impressive. Automated deployments and unit testing. Microsoft are pushing this forward with 2012 as SQL Server Data Tools...

Hi All,

Sorry I'm late to the party, but just wanted to post something for anyone to comment on as another method of solving the problem using date diff and...

This might be useful for ordering and defining the general periods;

-- Replace #EffectiveDate with your source of period date delimiters.

CREATE TABLE #EffectiveDate (

Effective_Date DATETIME);

INSERT INTO #EffectiveDate VALUES ('20110715'),('20110815'),('20110910');

-- Find period...