Very Computer

I suppose I could have separate pages for each employee
but I thought it would be more efficient to store them all
in one database. I am looking towards having a form
template so someone in HR could make the changes as needed.

Thanks in advance.

1. Create view for each department, or
2. A stored procedure takes department as input
parameter,or
3. put thing like this in your ASP code " SELECT * FROM
EmployeeTbl Where Department = '" & session(Department)
& "'"

Quote:>-----Original Message-----
>I am trying to build an intranet for our company with a
>SQL server database with all the employees bios in it. I
>will have separate .asp pages for each department. I
would
>like to have one db with all the employees and only the
>ones in a particular department show up on that page.
What
>would be the best way to set this up with minimal
>programming? Any ideas? This is my first time posting an
>inquiry.

>I suppose I could have separate pages for each employee
>but I thought it would be more efficient to store them
all
>in one database. I am looking towards having a form
>template so someone in HR could make the changes as
needed.

>Thanks in advance.
>.