thanx paul for ur quick reply.

But the problem persist.. The scope of the local variable "@dGetDt" ends in the exec statement itself...

I want the value of @dGetDT to do some...