You might also want to take a look at the Pivot command in Books Online. That might do what you need.

http://www.Simple-Talk.com (another of RedGate's pages), has an "SQL Pretifier" on it. There's a link on the front page. It will do that kind of color-coding.

Just to be clear: Are you doing this calculation in a query in the database, or in some reporting application?

If it's a query in the database, I can probably help...

Jeff Moden (4/16/2008)

---

Thanks, Gus... the order was to preserve Asimov's original order and because they can be broken down more simply as "Protect the data, protect the project, protect the...

Take a look at IsNull() and Coalesce() in Books Online. They'll do what you need.

What I'm seeing in the execution plan is mainly a cursor that should probably be replaced with an update command. If you're having trouble with the query, most likely...

There are a couple of ways to do this. One is:

select sum(col1), sum(col2),...

from

(select col1, col2, ...

from dbo.table1

union all

select -1 * col1, -1 * col2, ...

from dbo.table2) Sub

That will...

Jeff, I love it! I'd reverse the 2nd and 3rd, but it's still quite good.

On the article, I agree with the philosophy that the software exists only to serve...

I don't think it's possible. (Based on your post title, not the text. What you ask in the actual post is definitely possible.)

Glad we could help.

I have something similar happen before when one or more of the variables was null. Can you check for that?

SQL Server Express doesn't include SQL Server Agent. That's one possibility here.

Another option is to add a Timestamp (rowversion) column to the table, record that as varbinary in the history table, and compare records on that. Since the timestamp column...

The reason it's not working is because you can't have "select @TempTable.*" in a query. Also can't use the table variable name that way in Where, Having, Group By...

Since the temp table is created by dynamic SQL, it is only accessible within the same dynamic SQL.

You either need to add your inserts/updates/deletes and your final select, to the...