Thank you for the answer!

This works great but I came across an issue.

This is the sturcture of #t2 (temp table)

CREATE TABLE #t2

( ID INT IDENTITY(1,...

I think I should be more clear on what I need 🙂

Here is the set of data from which I have to select

DocID MilestoneDate ...

This code works great.

I would elaborate on my question if you don't mind.

Basicly what I want is

if MilestoneID = 10 or MilestoneID = 11 and not empty select more...

Thanks for the reply!

There is a primary key in my table (DocMilestoneID) which I omitted to include in the code I gave you 🙁

Sorry about that.

I will try your code.

Thanks

🙂 Should have known !!!

Thanks

Thanks for help

seems to be working.

How would you do it in the following case:

If MilestoneID = 35 Then

MilestoneDate

Else

getData()

So in our case result should be:

DocIDLatestDate

302012-10-18

312012-10-11

Thanks

Thanks for the reply.

In this case it is fixed number of Baseline columns.

Actually I like this idea of 1 table with flags 'U', 'D' etc.

Thanks again for all these suggestions and ideas. I learn a lot today.

DD

🙂

It is hard to explain and the process itself is very complicated.

More I work on it gets more confusing. :angry:

We want to show to our contacts what we have about...

I thought more in case when user deletes for example info in some specific field. Since I update just changed info into NeedApproval.Table, I wondered what I will do with...

How would you deal with the case when contact wants to delete some info we have in our system?

Thanks

DD

Thanks 🙂

Do you think it is reliable to keep staging table (in your case UpdateInfo_NeedApproval table) in the same db as the production table (in your case UpdateInfo table)?

Our web site...

Yes you are right , I want them to see what they have just enetered.

Thanks for such a detailed reply.

DD

One thing I forgot to mention is that when user login to web site we select his data and we display it to the user. After he updates it...