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

Please see this thread

Last I checked the Developer Edition of SQL Server 2005 (or SQL Server 2008) is still $50.00. Well worth the price.

Jack Corbett (1/21/2009)

---

Lynn Pettis (1/21/2009)

---

GSquared (1/21/2009)

---

Yeah, but did you see the reply to that?

What's up with the grapes table that only has a priority column? What does that have...

Grant Fritchey (1/21/2009)

---

Lynn Pettis (1/21/2009)

---

GSquared (1/21/2009)

---

Yeah, but did you see the reply to that?

What's up with the grapes table that only has a priority column? What does that have...