Has anyone heard anything about Barry lately?

Actually, once the OP explained him/her self, I can see where they copped that attitude - the "We're not here to do your homework" in...

Craig explained this:

which is causing you to link...

Please read this article[/url] for how to perform running totals.

Jeff Moden (11/10/2010)

---

It was a combination of things... OP had no clue... some people reacted in relative (perhaps even justifiable) disgust to that... the word "idiot" came out... and it...

Good catch GSquared.

No problem, I understand how that goes.

One thing about triggers - they should always be designed to handle > 1 row at a time.

You might want to check out this article[/url] for how to perform running totals.

Cross-posted. Please reply here.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66D3E6F5-6902-4FDD-AF75-9975AEA5BEA7

This looks like it should work. What kind of problem are you having.

You might want to take a look at the first article in my signature. Posting CREATE TABLE and...

It looks like you need to re-write your query to use a LEFT OUTER JOIN between the tables.

If you need more help, please read the first article in my signature,...

This code will make the one trigger set-based (trigger2). The other will take a bit longer... it's more complicated, and uses nested cursors. In the meanwhile, can you implement this...

In that case, you will need to use a function that splits the delimited string into the individual items, and returns them as a table.

Here is the latest version of...

This works for me in all databases on my SQL 2008 server:

DECLARE @XML XML,

@to VARCHAR(MAX),

...