Hi guys,
I installed the kit successfully and have two questions:

1. There is a latest job posting control which (in my openion) is for displaying latest jobs. When I post new jobs it does displays them correctly. I want last (not last n days) 20 jobs displayed. Any clues???

2. How can migrate data from the kit database to SQL server 2000?

-Rony

Hi Rony,

Re: 1.  There is a stored procedure called JobsDB_JobPostings_GetLatest.  This has a line in it:

SELECT * FROM [dbo].[JobsDb_JobPostings] WHERE postingdate >= (getdate()-7)

Change that line.

 

Re: 2. Best option I know is to use the database publishing wizard. 

Open the database.  <right click>. Select 'Publish to Provider' generate a script wth all the metadata to set up a new database, plus all the INSERT commands to insert the data.