Lynn Pettis (8/21/2009)

---

GSquared (8/21/2009)

---

GilaMonster (8/21/2009)

---

Oh. My....

set nocount on;

declare @String varchar(max);

select substring(@String + ',', Number, charindex(',', @String + ',', Number) - Number)

from dbo.Numbers

where Number <= len(@String)

and substring(',' + @String, Number, 1) = ','...

What do you want to do if someone is in there with two or more different e-mail addresses? Just make it so every entry has the first e-mail address?

luckysql.kinda (8/21/2009)

---

I want to make this topic more interesting.

Take a scenario when the DB is online and transactions are open and some work is going on (insert, update, delete)....

Oh trust me, nothin' anyone says will ever...

GilaMonster (8/21/2009)

---

Oh. My. That's in the...

Stick with procs. It can get messy, but anything else gets even worse.

I have an external drive that I back up to nightly.

I really should subscribe to one of the online services, but haven't yet.

I've used Macs, Linux, FreeBSD, and every Windows flavor except ME (which I deliberately missed).

Personally, I can't stand *nix, but I can understand the people who do like it.

Macs are...

ta.bu.shi.da.yu (8/21/2009)

---

You know what everyone was saying about bad answers... well, take a gander at the following Microsoft KB:

XL97: Data Not Returned from Query Using ORACLE Data Source

And I refer...

Silverfox (8/21/2009)

---

At the same time, I'm helping someone keep a job that they are quite possibly growing in to. I'm helping a company that might otherwise have to lay...

Ivanna Noh (8/20/2009)

---

@steve-2

How ironic...

What method did you use to copy the database?

Your update statement isn't written correctly.

Try this:

create trigger dbo.TrigTest

on dbo.Table1

for update

as

update t2

set desc2 = desc1

from inserted

inner join data2.dbo.table2 t2

on inserted.id1 = t2.id1;

What about holidays?

Your best bet for this kind of thing is a calendar table. Lots of uses, this is one of them.