Hi Ram .

this task can be accomplished by SSIS . if u worked with SSIS easily u can copy the values from source to Destination based on your condition...

Hi jeff,

thanks for your kind gesture .

could u reveal the logic behind the Query you sent .

Thanks in Advance!

Regards,

Sabari.C

hII jEFF

Thanks a lot

Hi sergy,

its not a assiginment .. part of my project . but they ask me not to use table fields directly u should specify the values to derive the date...

Hi chris,

i need a o/p in column .

anyway with the help of table only i will derive date value .. but for test purpose they ask me not to use tables . directly they ask me specify...

i need for to run the single line statement in Tsql without using any specific tables ..

thnaks for your reply . but i should not use table fields . without using how can we derive the o/p .