And what you told...

Holy cowabunga. Over there on the left when posting is IFCode shortcuts. They do a great job of helping format large code segments.

The real problem is that the code you...

Sean Lange (7/27/2012)

---

J Livingston SQL (7/27/2012)

---

Sean Lange (7/27/2012)

---

OK now we all have the same code to work from. Nice job posting readily consumable ddl and sample data. What I don't...

J Livingston SQL (7/27/2012)

---

Sean Lange (7/27/2012)

---

OK now we all have the same code to work from. Nice job posting readily consumable ddl and sample data. What I don't understand is...

Lynn Pettis (7/27/2012)

---

Not sure, Sean, but I know I had issues with some of...

OK now we all have the same code to work from. Nice job posting readily consumable ddl and sample data. What I don't understand is what you want for output....

Not sure what the issue with posting the code so I will help that. 😀

CREATE TABLE [dbo].[tempholes](

[id] [int] IDENTITY(1,1) NOT NULL,

[number] [int] NOT NULL,

[par] [int] NOT NULL,

CONSTRAINT [PK_tempholes] PRIMARY KEY...

pixelwiz (7/27/2012)

---

Hi Sean, you're right. I know. It's just been driving me nuts for 2 days and I can't even figure out how to explain it right. ...

That pretty much sums...

Did you already forget about the indexes question from last week? There have been plenty others that are far worse than this...

SQLTestUser (7/26/2012)

---

I have to create an update and insert trigger for a table based on the value of a column on the same table i.e. i have to add a...

Stefan Krzywicki (7/26/2012)

---

The very phrasing of the question makes me think this person isn't up to the task. I...

morepainot (7/26/2012)

---

I have no problem using CURSOR, as you can see by my original script. The people who have contracted have the problem with CURSOR. I dont care about using...

L' Eomot Inversé (7/26/2012)

---

Sean Lange (7/26/2012)

---

How many people don't share a last name with their PATERNAL grandfather? Only unmarried women, or those that chose not to take their husband's last...

It is pretty hard to help much without something to work with. We would need to see ddl, some sample data and desired output. Obfuscate your data to protect real...