Oh, actually a left outer join...

I have...

Not sure why you need the SUM or GROUP BY.

DECLARE @ACCOUNT TABLE

(

ACCOUNT CHAR(4) NOT NULL,

[DESC] CHAR(4) NOT NULL,

[SIGN] CHAR(4) NOT NULL

);

DECLARE @FACT TABLE

(

ACCOUNT CHAR(4) NOT NULL,

ORGANIZATION CHAR(3) NOT NULL,

[YEAR] SMALLINT...

dwain.c (6/14/2012)

---

Sean Lange (6/14/2012)

---

One requirement of a CTE is the previous line must end with a semicolon. As such many people have developed the habit of beginning a cte that...

That's half of us from last year.

SQL_NuB (6/14/2012)

---

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

Lynn Pettis (6/14/2012)

---

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports...

Sean Lange (6/14/2012)

---

One requirement of a CTE is the previous line must end with a semicolon. As such many people have developed the habit of beginning a cte that way.

;with...

Lynn Pettis (6/14/2012)

---

tpalmer (6/14/2012)

---

No. I am talking about SQL System Configurations (e.g. SP_CONFIGURE 'REMOTE ACCESS'). Default value is 1 (on) and we now need to set it to 0...

Dumb question,...

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports so no filtering right now, just put...

And these backup files aren't backed up to another location, file server or tape?

Are you talking about the ability to RDP to a server or SQL Server being able to accept remote connections (like from an application)?

Peer to peer replication is a form of transactional replication. It allows updates on either side.

Also, if you aren't using Enterprise Editon of SQL Server 2005, it isn't available...

When you t-log is 90% full (used), what does this query return:

DECLARE @DatabaseName VARCHAR(50);

SET @DatabaseName = 'VeryImportant' -- your database name here

SELECT name, recovery_model_desc, log_reuse_wait_desc

FROM...

nehaCS (6/14/2012)

---

SELECT

@ThisDate,

DATEADD(ww,-8,@ThisDate),

DATEADD(ww,DATEDIFF(ww,0,ISNULL(@ThisDate,GETDATE())) - 8,4),

DATEADD(ww,DATEDIFF(ww,'19000101',ISNULL(@ThisDate,GETDATE())) - 8, DATEADD(dd, 4, '19000101'));

So I understood the first part...