Okay, then I won't. 😉

I'm still confused as to what is being asked. How about more detail instead of a single line vaguely worded question. What are you trying to do?

milzs (2/1/2010)

---

We have a classified database (SQL 2K8 Enterprise) that interacts with a "classic ASP" application. This app/database is classified for program "A". Folks can update information within...

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...