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

cox1ray (7/26/2012)

---

is essential to take your company’s uptime during and after the disaster. begins with the development of an urgent situation plan. The first thing is pulling together...

capn.hector (7/26/2012)

---

vchandm23 (7/25/2012)

---

CREATE PROCEDURE [dbo].[myProc]

@whereSql nvarchar(256)

AS

EXEC('SELECT [fields] FROM WHERE ' + @whereSql)

GO

From stackOverflow website. This is what i was looking for. I am sharing this...

Stefan Krzywicki (7/26/2012)

---

Sean Lange (7/26/2012)

---

Stefan Krzywicki (7/26/2012)

---

Sean Lange (7/26/2012)

---

Here's a chuckle for you security types out there. I was trying reset my security questions today on the ADP site because...

manub22 (7/26/2012)

---

It is true you can make cursors more optimal than a while loop but why bother with them at all? In your examples there is absolutely nothing that can't...