Hi everyone,

I'm a beginner with SQL Server 2005 and trying to complete a project with the following question, can someone please help?

Use AdventureWorks database and HumanResources.Department table.

Create a stored procedure called spDepartmentAddUpdate.  This procedure accepts two parameters: Name, and GroupName.  The data types are VarChar(50), and VarChar(50) respectively.  Define logic in this procedure to check for an existing Department record with the same Name.  If the department record exists, update the GroupName and ModifiedDate. Otherwise, insert a new department record.

1. Execute your stored procedure to show that the insert logic works.
2. Execute your stored procedure to show that the update logic works.

  Note:

1.        DepartmentID is an identity column.

2.        You may use GETDATE() to insert or update the modified date.

Thanks in advance!

The SQL 2005 books online conain a lot of information for beginners. The sections on create procedure, insert statements, update statements and if - else statements will probably be of most use for this problem

If you are stuck, we'll be happy to give advice and assistance

So what, specifically, do you need help with?

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

As stated before your going to use update and insert of course but look at the keyword

EXISTS

and the functions

SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY (hint triggers and other events can affect the results of one or more of these)