thanks again, you've been very helpful indeed.

hi David!

I thank you much for your patience and help.

To answer your question concerning projectType column, that entire stored proc was the original one where the tasks are same no...

Hi David!

Please forgive me for bothering you again.

I am still confused about one thing.

If we say:

WHERE a.projectType = 'New DB Creation', are we not restricted the display to just this...

You are very good, indeed.

Thank you!(again)

hi David!

That is great, thank you but I still some issues here.

First, there will be a combination of projecttypes with tasks.

In other words, there could be one task associated with...

thanks a bunch for your help!

It is really appreciated.

you answered my questions, thank you!

One last one and I promise to leave you alone.

I am setting the initial values from the tblstatus table to 'not started' which has an...

Hi David!

A couple of follow up questions, please.

1, does it matter that @projectID is coming from tblproject table and is an identity?

2, what will be whereclause here for this:

SELECT @ProjectID,

t.taskID,

s.statusID

...

FROM...

Andy, what is a pick up folder.

I am more of a web developer than a sql guy.

Don't let the codes I wrote full you. It took me almost 3 weeks...

hi phillcart!

I actually wrote this program by looking at your second link.

I think I have figured out why it is not working.

I just don't know how to fix it.

Take a...