Ok, Looks like I have not provided sufficient details to get some help. Just to give you some more back ground I am working on migrating oracle DB to SQL...

Hi,

Thanks for your quick reply. I am new to SQL server infact RDBMS:-). So there will be lot of mistakes on my code.

I need help in understanding and making this...