Scot Morris (5/21/2015)
A very good point. And something all authors should consider when posting code/scripts. It is important to know where to get the sample database (and which version) on which the discussion is based. The adventureworks database has changed (and will continue to do so) over time to demonstrate the new features of sql server. The scripts in this article will fail with the current (2012) version.
uhmm, im sorry.. But im using SQL Server 2012, and everything seems fine.
Could you please show me which part of the script that should be getting fail in SQL 2012?
Im affraid i've using the wrong version of AdventureWorks DB :unsure:
FYI :
I used AdventureWorksDB 2005 which i downloaded from http://msftdbprodsamples.codeplex.com/releases/view/4004
..and attach it into my SQL Server 2012 without any problems