Jeff Moden (11/13/2010)

---

Lynn Pettis (11/13/2010)

---

First, Jeff, I thought that giving the OP some guidance in what direction he should look was appropriate. Sorry if that disappointed you, seemed the...

First, Jeff, I thought that giving the OP some guidance in what direction he should look was appropriate. Sorry if that disappointed you, seemed the right thing to do.

Second,...

First, we aren't going to give the answers to these interview questions, you need to research them yourself and determine what other methods you could apply to solve the problem....

Yes, yes I did....

Actually, I think I'm right. Just can't seem to reverse engineer this properly.

Okay, I think I'm wrong, back to the drawing board.

Craig Farrell (11/12/2010)

---

Lynn Pettis (11/12/2010)

---

John wants to...

Yep, unfortunately it doesn't solve the overall problem, which is being able to write scripts to test...

Okay, figured out a way to test the stored procedure and check the result set returned in the sys_refcursor without writing any sql code. Used the TEST feature in...

Ed Srdoc (11/10/2010)

---

My apologies.

I may have been put off by your initial response that ended in, 'We're not here to do your homework'. Maybe that wasn't directed at me....

First, how about posting the DDL for the tables, sample data for the tables (in a readily consumable format), and the expected results based on the sample data.

For help with...

It would help if you would post the exact error messages you are receiving. Hard to debug if we don't have that information.

You are always welcome to use my tent in the desert. I'll just...

Just to be sure, only the hourly differential backups are failing; the t-log backups are still running as scheduled when the differential backups fail.

Just a little more information is needed. Some sample data (as a series of INSERT INTO statements), and the expected results based on the sample data. About 5...