Vinit,

As Chandrachurh said, you can also use "Trigger" to do it...:)

Cheers!

Sandy.

if your TableY-Total columns contains null or no values then only TableX Total column will contain the Null value...

then whats wrong with that...??

Cheers!

Sandy..

karina,

check this, it may help you,

select cast('01/01/1990' as datetime) as sa_hidk

Cheers!

Sandy.

Good..

Means???

1st tell me where you got this file...;):P:):cool::hehe::w00t:

and do you have windows media player or not????:D:w00t::hehe::cool::):cool:

Cheers!

Sandy.

Yes, it will help you...ashok

and its easy to implements also....

just go through the books online and do it..:)

Cheers!

Sandy..

add the column name in insert statements...

hope it will help you..

Cheers!

Sandy.

gail,

I already said in the above post, I just skiped the question....:)

apology for this..:)

Cheers!

Sandy

gail,

you are correct, I said in sql 2000 and I skiped the question from 2005 to sql 2000...

Thanks gail for correct me...:)

Cheers!

Sandy.

Sharon,

I can suggest you few tips on how to improve your query performance. I can say its really difficult to say why your query is going slow, it may be...

Paul,

I can suggest you to create a function and pass the current date as the parameter and perform the calculation inside the function and return the value to you calling...

Nice concepts..

Good...

Use attach and detach method..

simple...:)

Cheers!

Sandy.