No, it's not helping

Yes, am using MS SQL 2000

Thanks for giving me the solution.

Actually, am working in my college project, where am creating an automate system for managing all the college activities like inserting student details, calculating students...

Sir,

In second_table, i inserted following data:

----------------------------

proj | valid_from | valid_to

----------------------------

ABCD 1/7/2009 7/7/2009

----------------------------

and in MAIN_TABLE:

--------------------

date |...

Thanks for replying.

I'll check the T-SQL and reply you back soon.

Thanks again!

The condition should be in another table column where only date will be provided.

Thanks A Lot!

Now it's working superb...THANKs A LOT!

Can I ask you another question?

Whenever am trying to populate this MyTable through updating from multiples tables,am getting the following error:

Key column information...

Sir, If am doing:

UPDATE MyTable

SET MARKS = 87

WHERE Student = 'Andy' and Course = 'ASM'

Its not allowing to enter the data on 2nd strike and showing...

Am talking about 3 strikes.

How can I use this counter column or the INSTEAD OF?

I don't want to use in my ASP as if I have to make changes in...

Am talking about 3 strikes.

How can I use this counter column or the INSTEAD OF?

I don't want to use in my ASP as if I have to make changes in...

GilaMonster (3/4/2009)

When rows are inserted into MyTable, the matching rows in DestinationTable are updated with cumulative...

Sorry, I did not get this question.

For update I used FOR INSERT, UPDATE syntax to make the trigger fire for both events means,...

Let me explain you in details:

Suppose, am entering followin data in MyTable:

insert MyTable select 'Steve', 'ASM01', 3, 50,0

insert MyTable select 'Steve', 'ASM01', 3, 43,0

Go

Now the Trigger which is attached with...

Whenever the data is being inserted in MyTable, the Trigger will automatically exceuted and filled the DestinationTable with following data:

--------------------------------------------------

Student course credit Grades Grade Points Quality

--------------------------------------------------

Andy ASM01...

--This is my StudentMark table, here I had inserted new column called ind_active!

create table dbo.StudentMark(

StudentMark_IDbigint identity not null,

Student_IDbigint not null,

Course_IDbigint not null,

AssgnMrk_IDbigint not null,

Markbigint null,

ind_activeCHAR(1)NOT NULL

Constraint c_ind_active CHECK (ind_active IN...