Now that I am at my desk I tested some stuff with your functions and I can't reproduce the issues you are seeing.

I did however make some adjustments to your...

For maintenance tasks that require looking at all tables or maybe even all...

$w@t (4/22/2013)

---

Hi all,

Can any one explain me What is the difference between Cursor and While Loop? I have read about two concepts but end up with confusion..Which...

autoexcrement (4/22/2013)

---

Maybe it's just an SSMS problem then. I didn't have any trouble creating the table and the default via SQL:

CREATE TABLE testfunc (checkdate datetime)

ALTER TABLE [dbo].[testfunc] ADD CONSTRAINT...

brian.battles (4/22/2013)

---

Hmm..have to see if I can figure out how to do that...I've done 99.9% of my SQL using pretty standard (but creative!) queries from VBA, MS Access, etc, and...

erikd (4/22/2013)

---

Well, this gets me the very end of an email. Not exactly what I was looking for. Oh well.

with rt as (

select right(email, len(email) - charindex('@', email)) as...

haiao2000 (4/22/2013)

---

Thanks Sean,

So after restored on a SQL 2008 R2 engine, the database being upgrated to 2008 R2 or is it still considered sort of SQL 2005 database running on...

I will assume that you still didn't read the article. You are much more likely to get help if you turn that into ddl (create table scripts) and sample data...

This will still work as long as there aren't more than 3 '.' in your value.

So things like 'http://www.maps.google.com' will work fine.

But 'http://www.mysubdomain.yourdomain.anotherdomain.com' will return NULL.

Use PARSENAME.

with MyData(url) as

(

select 'http://www.google.com' union all

select 'https://www.google.com' union all

select 'www.google.com' union all

select 'www.google.info' union all

select 'www.google.mobi' union all

select 'www.google.de'

)

select PARSENAME(url, 2)

from MyData

Sure no problem. It cannot however go the other direction....

This sounds like a very typical parent-child type of situation. How do you code for this? That depends entirely on what your ddl looks like. It might be a recursive...

mbhandari (4/22/2013)

---

How about this?

CREATE FUNCTION dbo.SplitString ( @string varchar(4000))

RETURNS @Result TABLE(SpiltedString VARCHAR(100))

AS

BEGIN

DECLARE @xml XML

...

Great.

Start a new thread with questions you might have.

Hi and welcome Florence. The forums here are a...