I think the idea of a persisted calculated column is a good idea. However, you will still need to use your function for that.

This may be a bit better. It...

Well, there is one...

First, lets look at consolidating those update statement. As an example, your first trigger has these individual update statements:

-- set or reset submittedBy based on...

In looking through your triggers, I see quite a bit of code that can be consolidated, making one update statement instead of ~10. I'll post an example of this shortly;...

Here's a T-SQL way to accomplish this (idea from this web site[/url]):

declare @sql varchar (8000),

@tbname varchar (100)

-- First table...

I threw some info out...

Is this the information that you're looking for?

process 1:

INPUT BUFFER: insert...

Here is a deadlock analyzing script I created some time ago... just save off your deadlock xml info to a file, and set the filename in the code (in the...

GabyYYZ (6/30/2010)

---

Lucky...still shell-shocked...

Sam Phillips (6/30/2010)

---

It sounds basically accepted that a clustered index should be the first index on a table (and that it should exist before the data is even loaded into...

Try splitting this line:DECLARE @CategoryId Int =

(

SELECT CategoryId

FROM dbo.[Forums.Categories]

WHERE ForumId = @ForumId

AND ParentCategoryId IS NULL

); --12;

into:

DECLARE @CategoryId Int;

SELECT @CategoryID...

Have you tried:

=Sum(Fields!total.Value)

Jeff Moden (6/27/2010)

---

Now, let's see if we can find all those tables...

SELECT Name AS TableName

FROM sys.Objects

WHERE Type = 'U'

AND Name LIKE...

pieterdv (6/29/2010)

---

Steve Cullen (6/29/2010)

---

The confusing part to me is you say records from one will not be in the other table. If that is so, you have no way...

Dave, can you add about a dozen rows of data for us to test with? (Do it in the form of insert statements!)

It looks like you're pretty close, but we're...