p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning Microsoft SQL Server 2008 Programming ISBN: 978-0-470-25701-2 (http://p2p.wrox.com/forumdisplay.php?f=425)
-   -   Can't find BuildAndPopulateEmployee2.sql (http://p2p.wrox.com/showthread.php?t=87047)

jsalyers March 22nd, 2012 11:23 PM

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--

Avtor July 28th, 2012 05:13 PM

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');

JARO August 4th, 2014 11:19 AM

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???


All times are GMT -4. The time now is 12:07 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.