This particular system only has three WBS levels:

Project WBS1

Phase WBS2

Task WBS3

When the system was implemented, the business development team decided that they only wanted to use WBS1 level, a...

Thank you for all of your help! 🙂

Here it is:

CREATE PROCEDURE dbo.insert_AssociatedContracts

@WBS1 varchar(30)

AS

INSERT INTO [dbo].[Projects_AssociatedContracts] (

...

Hall of Fammer,

Yours works beautifully. I see also the message regarding the insert and select values. I want the first and last name listed in Employee table...

Modified:

With the following errors:

Msg 102, Level 15, State 1, Procedure insert_AssociatedContracts, Line 3

Incorrect syntax near '@WBS2'.

Msg 137, Level 15, State 2, Procedure insert_AssociatedContracts, Line 34

Must declare the scalar variable "@WBS1".

I...

I meant to say that the PR table has over 40 columns.

The unique identifier will be WBS1. All specified data for each row is uniquely identified as belonging to the same WBS1. I'm pulling this specific set of data...

I think I understand. So I modified the code accordingly.

CREATE PROCEDURE dbo.insert_AssociatedContracts

@WBS1 varchar(30)

@WBS2 varchar(7)

@WBS3 varchar (7)

@Name varchar (40)

@ProjectMgr varchar (20)

@StartDate datetime

@EndDate datetime

@Firmcost decimal(19,4)

AS

INSERT INTO [dbo].[Projects_AssociatedContracts] (

...

I'm actually using all input parameters. I'm trying to make sure that all jobs (WBS2) and associated data

[WBS3],

...

Thank you! Guess that's why i'm a newbie 😀

Thank you for your quick response. I really appreciate it.

Yes, I was getting errors.

Now I get one error:

Msg 137, Level 15, State 2, Line 23

Must declare the scalar variable...