You just need to join and perform an aggregate calculation between the tables:

SELECT t.IDTask,

t.Name,

[StatusA] =...

Now that is a good like to have bookmarked.

Thanks!

10.0.4000 is service pack 2.

run "SELECT @@VERSION" - this will tell you the version, and whether you have RTM, SP1 or SP2 installed.

I believe that 10.0.1600 is RTM; I think...

Active nodes have at least one sql instance currently running on it.

Passive nodes do not have any sql instances running on it, but are ready to have another node's instances...

It sounds like the datatype for column X is a BIGINT. What is the datatype of column Y? Is column X an IDENTITY column?

Is the WHERE clause in the SELECT...

DougGifford (11/3/2010)

---

I have an SQL 2005 Develoment system with one table.

The table contains an encrypted column of data that was created using a master key, a certificate and a Symmetric...

Gail - do you know anything about SS2008's DBCC CHECKDB adding in checks for sys.parameters?

I just upgraded a server from 2005. Ran DBCC CHECKDB on all databases prior, and it's...

This might need to be run multiple times... you can't drop...

Hey guys - the reason I asked is two-fold:

1. If the service account running sql server has the "Perform volume maintenance tasks" right, creating even a 1TB db will only...

Would this work for you? (FYI - this is the first time I've ever used this function!)

DECLARE @test-2 TABLE (TestChar varchar(50));

INSERT INTO @test-2 VALUES ('Jackson-Green incorporated');

declare @FindStr varchar(50);

set @FindStr =...

Kit G (11/3/2010)

---

heh. Probably best if I just nod wisely...

My question is: Why would you want to do this?...

Well Kit, Gus just said everything I was going to... and since we both know he's always right... :w00t:;-)

GSquared (11/3/2010)

---

I'd have to see the rest of the query to be able to help much.

As an aside, take a look at uses of a Numbers or Tally table to...

Note that it's not a good design to have a field being a composite of two different definitions. Technically, this isn't even 1NF (first normal form).

You really ought to have...