Very simple: avoid looping. Almost every problem can be solved with set based code. You provided very little information, I suggest that you take a look at the article linked...

You could also create the split function separately, as it comes handy very often:

CREATE FUNCTION [dbo].[fSplit]

(

@Parameter VARCHAR(8000),

...

From SQL2005 the keyword WITH denotes a common table expression (CTE) that can be used in the query as an "inline view" to make code more readable or to achieve...

Always great stuff from you, Paul.

Well done.

Tom.Thomson (4/19/2010)

---

I haven't been hit by it yet, but I'm supposed to be flyin from ACE to MAN...

I don't understand where your "10 / (10 + 20)" comes from.

anthony_merriwether (4/19/2010)

---

If you do not see name caling, I suggest you read up a couple replies...things like 'Troll'. Last time I looked this is a noun by definition. ...

Jeff Moden (4/16/2010)

---

Heh.... famous last words would be... [font="Arial Black"]AHHHHH CRAP![/font]

Just so you guys know... remember I said that I changed my cteTally code to use Gianluca's wonderful idea of...

ROTFL! :hehe:

Have you tried handling errors in the triggers with TRY/CATCH?

You could ignore errors in the catch block.

Thanks Jack! Sometimes I feel dumb when I don't understand your jokes...

I'm sure I'll...

Lynn Pettis (4/16/2010)

---

Gianluca Sartori (4/16/2010)

---

Luke L (4/16/2010)

---

So is there a good way to search within a thread specific thread? Looking for information from earlier in this thread. Someone...

Luke L (4/16/2010)

---

So is there a good way to search within a thread specific thread? Looking for information from earlier in this thread. Someone suggested using Milk as...

You have to switch off the partitions you don't want any more with ALTER TABLE {table_name} SWITCH PARTITION {partition number} TO {destination table}. Thereafter you can drop the table if...