Recruitment sample database - Where can I get it?

[alberteinstein]

Hi

Could anyone tell me where i can get recruitment sample database that is present in SQL Server 2000?

I have SQL Server 2005 Express with me.
Microsoft's site offers Northwind & pubs sample database download for use with SQL Server 2000 (which also works in server 2005).But it doesnt offer the sample recruitment database.

I havent been able to find the recruitment database anywhere on net (Yes.I googled a lot)

Please help.
Thanks.

Albert.

p.s: I do have access to a server 2000 machine that has the recmt db,but I understand merely copying the MDF file doesnt work?It has to be 'installed' with query right?

 

[jbenson001]

I have never heard of the recuitment sample db. You can detach the db from the machine that has it, copy the .mdf and .ldf files, then attach it on the pc that you want to run it on

Jim

 

[SQLBill]

What 'recruitment' database? I have SQL Server 2000 Enterprise Edition and the only sample db's I know of are Northwind and Pubs.

-SQLBill

Posting advice: FAQ481-4875

 

[alberteinstein]

@jbenson : Tough luck.Access to the folder where MDF files are stored is denied!

@SQL Bill :Well,its probably not installed with Server 2000 default or something like that.

Iam actually learning SQL from a course book that uses only these 2 sample databases - Pubs & Recruitment.
I guess it has to be there somewhere!

Thanks.

 

[AlexCuse]

I've never heard of this recruitment database. Are you certain it is not to be installed from a cd that came with the book?

Good Luck,

Alex

It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.

 

[onressy]

i'm trying to do this in an stored procedure:

strSQL = "Select TOP 1 InventoryDate From Inventory Where ProductID = " & varProductID & " AND InventoryDate >= '" & varRateEndDate & "' AND Inventory.GDS=1 AND Inventory.prodID<>'' AND Inventory.roomCode<>'' AND Inventory.Available > 0 ORDER BY InventoryID ASC"
Set objRS = DbExecuteReturn(strSQL)

Dim a11a, a11b

If NOT objRS.EOF Then
a11a = objRS("InventoryDate")
End If

strSQL = "Select TOP 1 InventoryDate From Inventory Where ProductID = " & varProductID & " AND InventoryDate > '" & a11a & "' AND Inventory.GDS=1 AND Inventory.prodID<>'' AND Inventory.roomCode<>'' AND Inventory.Available > 0 ORDER BY InventoryID DESC"
Set objRS = DbExecuteReturn(strSQL)

If NOT objRS.EOF Then
a11b = objRS("InventoryDate")

//return alla and allb values

End If

this is what i have and i'm stuck:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

CREATE PROCEDURE "spGetInventoryFirstValueAndLast"

@varProductID int,
@varRateEndDate varchar(20),
@prodID varchar(20),
@GDS int 1,
@Available int 0

AS

Select InventoryDate From Inventory 
Where 
    Inventory.ProductID = @varProductID 
AND Inventory.InventoryDate >= @varRateEndDate 
AND Inventory.GDS=1 
AND Inventory.prodID<>'' 
AND Inventory.roomCode<>'' 
AND Inventory.Available > 0 
ORDER BY InventoryID ASC

/*  How can i return only the first InventoryDate and the last InventoryDate? */

 

[gmmastros]

Declare @MinDate DateTime
Declare @MaxDate DateTime

Select @MinDate = (Select InventoryDate From Inventory 
Where 
    Inventory.ProductID = @varProductID 
AND Inventory.InventoryDate >= @varRateEndDate 
AND Inventory.GDS=1 
AND Inventory.prodID<>'' 
AND Inventory.roomCode<>'' 
AND Inventory.Available > 0 
ORDER BY InventoryID ASC)


Select @MaxDate = (Select InventoryDate From Inventory 
Where 
    Inventory.ProductID = @varProductID 
AND Inventory.InventoryDate >= @varRateEndDate 
AND Inventory.GDS=1 
AND Inventory.prodID<>'' 
AND Inventory.roomCode<>'' 
AND Inventory.Available > 0 
ORDER BY InventoryID DESC)

Select @MinDate As MinDate, @MaxDate As MaxDate

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[manmaria]

what is going on here? Two threads got mixed up?

If you are learning from a course book, either they would have given the CD to install or there should be a link behind the book to download the code/DB.

 

[alberteinstein]

The book did not come with a CD.

"You can detach the db from the machine that has it, copy the .mdf and .ldf files, then attach it on the pc that you want to run it on"

How exactly do I do that? [ Incase I come across a Comp that does have that database]

 

[SQLBill]

This 'course book' you are using. Is this from a course you took or are you using someone else's book? Sometimes a 'school' will create their own databases to use with their courses and they are only available at the school. When I took Oracle courses from Learning Tree, they have a database that isn't available via Oracle. They do allow students to make a copy to take home and use. So, I'm guessing that you have a 'school course book' and that the database you are looking for is particular to that school's courses. If you paid for the class, you should be able to get a copy of the database from the school. But if you are using someone else's book - you are probably out of luck.

-SQLBill

Posting advice: FAQ481-4875

 

[alberteinstein]

I managed to get the required script file & installed the database.

Issue resolved.

Thank you everyone for your response.

 

[SQLBill]

So where did you get it? Was it a 'school supplied' database? This would be good information to post in case someone else looks for the same database.

Even if you solve your own problem, you should always post the solution. You never know when it might help someone else.

-SQLBill

Posting advice: FAQ481-4875