I tend to dislike "syntax error" questions since they are usually easily corrected. Double click the error, find the line, examine it.

However there are lots of people that don't seem...

TravisDBA (7/13/2010)

---

Private clouds require considerable upfront investment in both hardware and software, so they are not a good choice for small and medium sized companies operating currently under tight budgets...

dhamilton-905368 (7/13/2010)

---

Steve,

I couldn't agree more, but have a couple of questions...

1. When were you working with this DB2 system -- I'm not particularly versed...

Paul brings up a good point, but it depends on scale. I've had large, million row tables where the deletes were < 10% and didn't really cause issues. And they...

You can implement it at the front end or back end. However, if you do it at the front end, then every time to make a call that touches data,...

Nice, Paul. I assume those are provided for testing, or other solutions and not for this problem. It's overkill and inefficient for what the OP is trying to accomplish here.

Can you explain what you are doing or thinking here? Is this an interview question of some sort?

jcrawf02 (7/12/2010)

---

mbricker-600840 (7/12/2010)

---

I agree whole-heartedly with Jeff. IT is there to serve. Too many people forget that.

Oh, and another thing, I certainly hope I provide service that is MORE stable...

This is usually something you'd do in the client. You could potentially check for the row count (select count(*)) and if it's < 17, then you can add in a...

Are you sure?

http://msdn.microsoft.com/en-us/library/ms188062%28v=SQL.100%29.aspx

What are you supposed to do if there are less than 17? Include zeros? Or not run the report?

How is the report being run?

I agree with Emily. Any hiccup will cause the backup to fail. Typically you back up locally and then copy to another server.

Is this some type of test question? We are not here to do your homework/exam work for you.

I'm still not clear what the starting criteria is. If I am searching...

It's not quite clear what you mean to me. You want to compare every record to every other record? Or given a particular record, find other records who have...

Gianluca Sartori (7/12/2010)

---

Alvin Ramard (7/12/2010)

---

Another thing that made me wonder about the OP was the way he/she communicates. Start a sentence with "like I went to the view i...