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



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

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,

INSERT INTO HumanResources.Employee2(EmployeeID,ManagerID,JobT itle,LastName,FirstName)
(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 11:05 PM.

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