I'm using the self paced training kit Exam 70-448: MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance.
When you download the Adventure Works database sample at http://msftdbprodsamples.codeplex.com/releases/view/55926, you'll find it doesn't include the AdventureWorks2008 sample being called for. No big deal. It's the same database as AdventureWorks with some date changes.
I did my first pass through the book pointing to AdventureWorks in my connection strings and when later SSRS lessons were calling for dates that were out of rage (2004-2008), I ran a quick query against the fields in question in SSMS as follows:
Use [Database]
Go
Update [Table]
Set [xField] = DATEADD(year,3,[xField])
This run through the book I used the export wizard against AdventureWorks and created AdventureWorks2008. Now I'm pointing to AdventureWorks2008 in my BIDS connection strings and I'll update dates when needed.
No comments:
Post a Comment