Did you report it?

As many times as people used to working with Excel start working with SQL. 😉

Your where clause effectively turns your outer join into an inner join. Try the following query:

with Myft as (

select

ft.fdata,

ft.no,

...

Actually, since you are running SQL Server 2005, if yoour account has SysAdmin rights you can still can access to your system. You will need to restart SQL Server...

You can find the syntax for the BACKUP DATABASE command in Books Online.

First, I just took an example that someone else started.

Second, very well said, Matt, and I agree.

Paul White (1/31/2010)

---

Avoid string manipulation of dates and times if at all possible.

An alternative approach might be:

DECLARE @DateOnly DATE = GETDATE(),

...

David Portas (1/31/2010)

---

Does...

Still don't see SQL, or its variants (T-SQL, PL-SQL, etc), going away any time soon. Just like COBOL, I see it having a long life, or at least until...

bitbucket-25253 (1/30/2010)

---

Lynn Pettis

Always thought that was a fallacy - what...

Florian Reischl (1/30/2010)

---

Yup, this makes it easy to skip some tweets.

(BTW: One non-technical thing I really love...

Jeff Moden (1/29/2010)

---

Lynn Pettis (1/29/2010)

---

Actually used it to capture data changes while developing a data modification process when I needed to do destructive testing in a test environment and didn't...

Actually used it to capture data changes while developing a data modification process when I needed to do destructive testing in a test environment and didn't want to have restore...

Table variables are also not affected by transactions. They are good for capturing data inside transactions regardless if the transaction is committed or rolled back.

WayneS (1/29/2010)

---

Lynn Pettis (1/29/2010)

---

.... You should also script out all jobs in msdb. Probably all the logins (sans passwords) in master as well. You will have to...