Dennis D. Allen (1/21/2009)

---

Greetings Lynn,

Yes that does work and is a fine workaround.

I want to understand why this does not work as it should work correctly and the...

Unfortunately, no. Using your sample data, what would you like to see as output.

Input --> Process --> Output.

You have given me the Input, give me the Output, and I'll...

Format by hand do I.

Use the Force Luke...

Actually, nothing wrong with posting an answer that's already been posted. One thing you'll see is a difference in formating styles.

Dennis D. Allen (1/21/2009)

---

I have a parent child relation between to tables. Not all parents have children, some parents have 1 or more children. I want all of...

airborn (1/21/2009)

---

Lynn - from what I understand this code will just pull the outcome, staff, etc for 2007. But how would you add all the records for outcome then get...

hmmm, Got "it" I think he has!

Gail, From the original post, it looks like it was allowed to grow due to a lack of backups being taken on the log file. If they start running...

Okay, is this what you are trying to accomplish?

--===== Create the test table

CREATE TABLE #apples

( ...

Here is...

Tell me if I am wrong, but aren't the last 2 the same as the first?

GSquared (1/21/2009)

---

Lynn Pettis (1/21/2009)

---

You also have a problem with the following data.

INSERT INTO #grapes

(win_id, priority)

SELECT '19820865478765','1' UNION ALL

SELECT '19820835478765','5' UNION ALL

SELECT '19820895478765','4' UNION ALL

SELECT '19820865438765','2' UNION ALL

SELECT...

You also have a problem with the following data.

INSERT INTO #grapes

(win_id, priority)

SELECT '19820865478765','1' UNION ALL

SELECT '19820835478765','5' UNION ALL

SELECT '19820895478765','4' UNION ALL

SELECT '19820865438765','2' UNION ALL

SELECT '19820865478765','1' UNION ALL...

You are missing one last thing from your last post. Go back and look at your sample data. Based on that data, what is the expected output you...

As mentioned earlier, the active portion of your transaction log may be at the end of the log file. If that is the case, you won't be able to...