adventureworks

AdventureWorks presentation

Hello all, I want to implement an application (scholar exercise) over the AdventureWorks database. I have downloaded the diagram. Is there a less formal description of the database? Thanks, Lucian ...

Northwind Starters Kit

Is the Northwind Starter Kit from Codeplex a good starting point to learn more about how to best architect an ASP.NET application? Is there something similar for the AdventureWorks database examples? ...

Can't download adventure works database 2005 from codeplex

Can't download adventure works database 2005 from codeplex. Where else can I find and download it??? I've been searching it online, I found some results but i can't download any of them. Any help is appreciated ...

create hierarchy in non parent child dimensions

I am creating a user hierarchy for product dimension with AdventureWorksDW in a cube. I have added Product Key, ProductCategory Key and Product Subcategory Key attributes. But, its always giving me a warning "create hierarchy in non parent child dimensions" as a tooltip as I hover my mouse pointer over the Dim Product in Attributes windo...

Is there an alternative to the Adventureworks database for SQL Server 2008?

I want to use something lighter than adventureworks. Is there an alternative at all? I have had a look at the Chinook database, but I just want see if there is an alternative. Google search doesn't help either. ...

F# Code for Adventure Works Sample

hey everybody, it is very hard to find good samples for f# in the web. some samples show a simple web crawler for downloading stock data from yahoo or only code snippets of bigger ideas. i'm searching for an real world example outside the financial world. what about adventureworks? the current sample database is the base of many c# sam...

SQL Invalid Object Name 'AddressType'

I am getting the above error in my VS 2008 C# method when I try to invoke the SQL getColumnNames stored procedure from VS. This SP accepts one input parameter, the table name, and works successfully from SSMS. Currently I am selecting the AdventureWorks AddressType table for it to pull the column names from this table. I can see teh A...

In T-SQL how to display columns for given table name?

I am trying to list all of the columns from whichever Adventureworks table I choose. What T-sQL statement or stored proc can I execute to see this list of all columns? I want to use my C# web app to input one input parameter = table_name and then get a list of all the column_names as output. Right now I am trying to execute the sp_col...

Question on AdventureWorks DB...What is the point of rowguid in a lot of the tables?

So I think I already know the answer to this question... Running AdventureWorks2008 (latest version) on mssql server 2008. I am thinking that the rowguid column in a lot of the tables is to ensure that there is a primary key. I am probably dead wrong as the column appears to be a constraint. Correct me if I am wrong and also please cor...

SQL AdventureWorks count employees by gender by city

Hi, I want to count the cities by gender, like this; City GenderFCount GenderMCount Redmond 10 20 Here is my query gets city and gender in AdventureWorks database select Gender,City from HumanResources.Employee as t1 inner join HumanResources.EmployeeAddress as t2 on t1.EmployeeID = t2.EmployeeID inner ...

Is there a web application layer over AdventureWorks?

I'm wondering if anyone has implemented a web UI on top of the AdventureWorks database? IOW, I'm not looking for just a application data layer on top of the schema. Rather, I'm wondering whether anyone has created an ecommerce front end on top the AdventureWorks schema? ...