Hello Ken / Wayne,

Wish you all Happy New Year !

Hello ) ) ) ) ) ) ) ( ( ( ( ( ( ( ( .............

Anybody In ?

Hello,

Anybody please help me ! :unsure:

Hi Wayne,

initially it seems to me like dual table from oracle. But it is something more than that I guess. turning my heads on !

It is a good facility as...

Hi Ken,

You rock man ! I got your trigger to work finally without any changes ! There was a problem in my database inserts. It was not picking up the...

Thanks Paul, for your...

Hi Ken,

I am sorry a mistake I made was that I deleted my trigger (fine) now when i copied your trigger and executed, it was alter trigger, so i converted...

Please refer my next post.

Thanks Ken,

you have correctly pointed out, the logic is that each class is having a start and end date (divisionwise). If I enter any period in this table then first...

Anybody Please help ! Hello ! I hear echo ! :w00t:

Greetings !

I am a freelance programmer in php and sql server. previously I designed ERP solutions in oracle and they are successfully running for past 15 years, but sql server...

Hello Wayne,

I am sorry dear, that was totally unintentional and happened casually, I just put the case as I found simpler. I am a noob in sql server 2005. I...

to make the forum simpler I have given you another simpler example in my first post, actually it is an example of student master. so instead of account master use...

Hi wayne,

Actually i already have a insert trigger for other processing, shall i create a different trigger in addition to my existing insert trigger, i have done so, but it...

What ER Diagram this noob can share with you professionals ? :hehe: I think Mr. Grant has given a good solution. I will implement it.

Thank you professionals for yours...