Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning Microsoft SQL Server 2008 Programming ISBN: 978-0-470-25701-2 Discuss the book Beginning Microsoft SQL Server 2008 Programming, Robert Vieira, ISBN: 978-0-470-25701-2
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Microsoft SQL Server 2008 Programming ISBN: 978-0-470-25701-2 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 22nd, 2012, 11:23 PM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can't find BuildAndPopulateEmployee2.sql

The book says this file is in the downloads but I downloaded the files and can't find it anywhere.

Can someone direct to where to find it...?

Thanks!

J--
 
Old July 28th, 2012, 05:13 PM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2012
Posts: 1
Thanks: 0
Thanked 2 Times in 1 Post
Default

you need to download source codes and execute them for each chapter
this one will create new table HumanResources.Employee2
make sure you work with in Advenute work

paste this code in your SQL Query and execute
Start From HERE:

USE AdventureWorks
GO

CREATE TABLE HumanResources.Employee2
(
EmployeeID int NOT NULL,
ManagerID int NULL REFERENCES HumanResources.Employee2(EmployeeID),
JobTitle nvarchar(50) NOT NULL,
LastName nvarchar(50) NOT NULL,
FirstName nvarchar(50) NOT NULL,
CONSTRAINT PK_Employee2_EmployeeID PRIMARY KEY CLUSTERED (EmployeeID ASC)
);

INSERT INTO HumanResources.Employee2(EmployeeID,ManagerID,JobT itle,LastName,FirstName)
VALUES
(1, NULL, 'CEO','Smith', 'Hunter'),
(2, 1, 'CFO', 'Jones', 'Drew'),
(3, 1, 'COO','Lenzy','Sheila'),
(4, 1, 'CTO', 'Huntington', 'Karla'),
(5, 4, 'VP of Engineering', 'Gutierrez', 'Ron'),
(8, 5, 'VP of Engineering', 'Gutierrez', 'Ron'),
(9, 5, 'Software Engineer', 'Bray', 'Marky'),
(10 ,5, 'Data Architect', 'Cheechov', 'Robert'),
(11 ,5, 'Software Engineer', 'Gale', 'Sue'),
(6, 4, 'VP of Professional Services', 'Cross', 'Gary'),
(7, 4, 'VP of Security','Lebowski','Jeff');
The Following 2 Users Say Thank You to Avtor For This Useful Post:
milad0101 (November 6th, 2012)
 
Old August 4th, 2014, 11:19 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Lightbulb Unable to get source code

Hi Beautiful

In chapter 3 the book requires you to download BuildAndPopulateEmployee2.sql but I cant find it please help! what can I do???




Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't find my SQL Express snorberg BOOK: Professional ASP.NET MVC 2 1 September 15th, 2010 09:58 AM
Where to find Time Tracker database - SQL junkerp BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 May 9th, 2009 07:29 AM
Can't find SQL Management Studio exe anywhere? Snakum ASP.NET 2.0 Basics 2 August 7th, 2007 09:07 AM
use SQL to find a record linmu VB.NET 2002/2003 Basics 4 May 6th, 2005 05:03 PM
sql command to find duplicate records? qwjunk Classic ASP Databases 1 January 31st, 2004 03:32 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.