Well, Thank you guys for all your response. In real-life its just not website but some IP addresses. Website addresses ending with .net / .org/ internam domains etc and some...

The second one works better for me..

Thank you. Much easier now... 🙂

Its Perfect.. 🙂

Anyone who can help pelase...

Thanks Tara.

I could use HTML and get teh desired output.:-)

Thanks for the feedback. I figured it out. There were mistakes in my post as well which i corrected following the best practices link. Thanks Guys 🙂

This is the exact data with minor modifications (The entire text goes into a single field and i need to extract first name, last name, middle name if present, ...

In fact there is a small problem.I get the error message

Invalid length parameter passed to the substring function.

I have an idea that it couldbe happenig because of null/ negative...

Thanks for your help guys.

It worked great. I'm so happy :):-D

Guys,

Journeyman's feedback makes sense. I have starting using SSRS recently.

I have created views for each report. So I got to a project -> run the report server wizard and...

Thanks Steve. I'll work with your example.

I have one more question. How do I schedule multiple reports? I mean multiple reports should go in one mail (preferrably zipped /...

Hey steve

This is a loud shout for the example 🙂

And hey Grasshopper

since the reports are geberated and sent by SSRS how wud i include excel formatting/ , macro. it really...

Can someone help please?... It shouldn't ne a tough one for sql geeks 😀

Ramesh 🙁 . It gives teh following error :

Arithmetic overflow error converting expression to data type datetime.