Hello,

I use Java & Oracle, not .NET & SQL Server. Nevertheless, unless I am missing something about .NET, you need a 'commit' after the update and before you close the connection. Otherwise after...

campkev,

I don't have much experience with Microsoft SQL Server, I use Oracle. However this is how I would approch it in Oracle. The syntax may be different in SQL Server but the principal will be...

Well if you must do it in SQL and not the front-end, this is how I would do it in Oracle:


select 'Work', 'Work' from dual
union all
select 'Code', 'Nature' from dual
union all
select...

sqlchopper,

If this SP can be run by something other than the web app, then why not create a batch file which uses 'sqlplus' to connect to the DB to run the SP. This can be scheduled to run...

As I have said I do not now the older version of ASP, only .NET. If you want to do some reading up on using .NET to access databases the links below are a good place to start:
...

You would do that kind of thing in the client application displaying the results

I am not sure I follow you exactly when you say you want to join several tables in stored procedures, but if your trying to produce a page which is data sourced from several tables, why don't you...

I don't have any experience with the older version of ASP I am afraid, I have only ever used ASP.NET and ADO for Database connectivity on a web project. Why do you specifically want to use ODBC by...

I don't see that you have missed anything in setting up the database. What language do you intend to use on the frontend? PHP, ASP.NET etc ...

It appears you are trying to setup a one to many relationship between job_title -> employee. This would imply that one employee can have one job_title and one job_title can be assigned to many...