Sample database for 2008R2 SSIS

I have the sample files, so I don't need those. but for the life of me I cannot find the AdventureWorksDW.mdf for the SSIS tutorial. it's referenced in the SQL Server 2005 install, I believe, but I...

Id #22319 | Release: None | Updated: Aug 1 at 8:20 AM by timc_fla | Created: Aug 1 at 8:20 AM by timc_fla

Sample database with JP data for SQL Server 2008R2

Hello, My project requires JP data to displayed in the report. However, due to time constraints, i could not create one from scratch. Is there any sample database (like adventureworks) with JP da...

Id #22248 | Release: None | Updated: Apr 20 at 6:25 AM by Paarisha | Created: Apr 20 at 6:25 AM by Paarisha

problem with T-SQL query on SQL Server 2008

Hello, I have an error message on one of my t-sql queries in my PHP code, and I not find the error so if anyone can help me SELECT dbo.GROUP_CONCAT("<span style=color:", IF([dbo].events_categorie...

Id #21950 | Release: None | Updated: Jul 23, 2015 at 11:54 AM by ilyas8 | Created: Jul 23, 2015 at 11:54 AM by ilyas8

Will there be SQL2014 Samples soon?

Hi Guys, love the work you're doing here, but can we expect SQL2014 based samples any time soon or should we be just using the olders ones? E.g. SQL2012. Thanks Craig

Id #21112 | Release: None | Updated: Jun 30, 2014 at 5:25 AM by CraigHumphrey | Created: Jun 30, 2014 at 5:25 AM by CraigHumphrey

DimProduct error

The table DimProduct of the Adventure Works 2012 DW seems to be incomplete, as for example SubCategorykey is null and son on.

Id #20725 | Release: None | Updated: Feb 12, 2014 at 10:35 PM by darktagnan | Created: Feb 12, 2014 at 10:35 PM by darktagnan

AdventureWorksDW2012 Download file corrupt

There seams to be an issue with the AdventureWorksDW2012 Data file download. When I try to run this SQL statement: CREATE DATABASE AdventureWorksDW2012 ON (FILENAME = 'E:\MSSQL11.SQL02\MSSQL\DATA\...

Id #19063 | Release: None | Updated: Feb 22, 2013 at 1:37 AM by dscheierman | Created: Dec 14, 2012 at 4:05 PM by dscheierman

SQL Server 2008 Developer edition sample database install error

I'm trying to install Adventureworks sample dB and i get an error. I successfully downloaded the mdf file however when attach, add and click OK from SSMS I get the error:   Msg 5172, Level 16, Stat...

Id #18174 | Release: None | Updated: Feb 22, 2013 at 1:37 AM by pleasehelpme99 | Created: Jun 2, 2012 at 12:07 AM by pleasehelpme99

Looking for SSAS 2008R2 Enterprise AdventureWorks OLAP Project Download

The AdventureWorks 2008R2 SR1 Installer has been removed or is no longer available here: http://msftdbprodsamples.codeplex.com/releases/view/55926   This appears to be the only place to download ...

Id #18022 | Release: None | Updated: Feb 22, 2013 at 1:37 AM by mtnbikePeru | Created: May 9, 2012 at 9:31 PM by mtnbikePeru

New to datawarehousing...and want to know how the Adventurework and AdventureworkDW has been developed

New to datawarehousing...and want to know how the Adventurework and AdventureworkDW has been developed.. how the OLTP data has been extracted to AdventureworksDW..datawarehouse system and need some...

Id #17881 | Release: None | Updated: Feb 22, 2013 at 1:37 AM by bsurendiran | Created: Apr 19, 2012 at 11:57 AM by bsurendiran

A dynamic report menu page

We have a .net app and of course it requires reporting future. Anyone uses this app is going to login and base on database roles (stored in an Oracle DB) they are able to see their screens on this...

Id #14903 | Release: None | Updated: Feb 22, 2013 at 1:37 AM by rv7a99cv | Created: Dec 17, 2010 at 12:09 AM by rv7a99cv