Thanks for the valuable feedback. I have one more follow up question, assuming that i have a stand by server to mirror the prod DBs and the server is in...

So, is there any other way to do it ? if we cannot afford a second production server?

Awesome. 🙂

I will keep the back up plans to myself,Instead i will approach them with Questions you mentioned.

Thanks a lot

Thank You all for your good peices of advice. Will keep them in mind and act accordingly.

Thank You Richard it was useful.

Thank You

@celko

Thanks for the info it was very helpful.

Well i know placing similar data into three different tables has nothing to do with RDBMS. But it was a...

Got it. Thank You.

Second set of data is exact.

The date part has to be extracted from right.

Coz the number of prefix charecters vary for each record.

Thanks for the very informative feedback.

I thank all the commenters.

Love this forum. 🙂

Yes, but what would be the condition in case ?

with what condition can i filter all invalid input formats ?

Can i say if the i/p is number and of...

Thank You but the conversion failed. The error was

Conversion failed when converting datetime from character string.

Then i realised that some of my cells had invalid date formats in them...

u mean to say that if my data is like

20071101

20071101

20071101

20071101

20071101

it get converted perfectly ?

will i be still getting MM/DD/YYYY with my above mentioned convert statement ?

Thanks

Ohh NO....

How silly...

My bad

Thank You

Any ideas or sugestions from vets wud be greatly appreciated.