..

..

hey linn thanks,

if i need any help means i ll scrap u..

Regards

Prasad

hey gail,

thanks a lot..

regards

Rajendra prasad

hey gail,

i didnt have any sample data and everything its just scenario which my TL gave to me.

i dont know how to use that..

he ask me to create own table...

hey linn,

i didnt know that much of using cursor,

frankly through niit only i learn sql.

there didnt teach me how to use cursor and everything..

now i am working in one organisation...

hi dude

hey can u send me the sample table with queries by using trigger..

Regards

prasad

Please post table definitions, sample data and desired output

Dear ,

THANKS FOR UR SUPPORT.

i want to do that by using cursor program not in trigger..

U CAN CREATE OWN TABLE AS U...

select id,'total'=a+b+c,date from table_name

i think u r sql server is not install properly...bcoz u r querry is absolutely right  by prasad