In select statement You can use

CONVERT(VARCHAR,insert_dt,110)AS CreatedDate

to get the same date format as you expected from following

right('0' + rtrim(month(insert_dt)), 2) + '-' + right('0' + rtrim(day(insert_dt)), 2) + '-' +...

that was Helpful information.

Thanks all for your time.

I am halfway done in my task.. It would be helpful if you pass the script..

Thank you very much for everyone who tried to contribute..:-):-)

Thanks for your time & suggestions.. I already started working by examining each SP seperatly.........

🙂

Hi All,

Could anyone please assist me with above scenorio.......:(