bruce.trimpop (4/14/2009)

---

Matt Whitfield (4/14/2009)

---

bruce.trimpop (4/14/2009)

---

I put forth a real world problem to that person that I could find no way to accomplish without using a cursor. I never heard back...

We need the DDL for the tables and some sample data for the tables (in a readily consumable format). The sample data should have data that should be deleted...

dbishop (4/14/2009)

---

I must say that for an introduction you did an okay job. The only thing I took offense of was the procedural vs. declarative examples and your definition of...

Jeff Moden (4/14/2009)

---

Lynn Pettis (4/13/2009)

---

I made a slight change to the data loaded. I kept the data the same in both tables this time and here are the statistics...

yulichka (4/14/2009)

---

I run this: and get error:(he DELETE statement conflicted with the REFERENCE constraint "FK_packages_package_lists". The conflict occurred in database "CSWReportDatabase", table "dbo.packages", column 'packagelist_id'.

The statement has been terminated.)

My code:

SET...

There are several of us who would take on the challenge of attempting to rewrite a cursor based solution as a set based solution. If you take up the...

Check out the code in this post.

There I have one method being used. If you read the following post, you will also notice I did a second run making...

yulichka (4/14/2009)

---

Thank you everyone for your response, All I am trying to do delete data from the table where date >=30,to schedule a job to run every month. Is my...

As you are currently using SQL Server 2005, I'd certify on that platform first. You can upgrade your cert as you migrate to SQL Server 2008. If I...

I made a slight change to the data loaded. I kept the data the same in both tables this time and here are the statistics io and time for...

I guess I didn't do a good job of explaining what I found. I rewrite the code some, and it is posted below along with the statistics time and...

Here is the link http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/04/05/dealing-with-difficult-forum-users-the-flip-side.aspx#comments.

In my blog, th flip side, I mention that the post should be concise yet detaled. Sort of an oxymoron, but it works.. The code should be well formatted...

Here is my take. When you look at your post, could someone with no knowledge of the problem domain understand the problem you are presenting. If so, then...

Flo,

If you check my code, I created the temporary table (#TestData) with definition defined as nvarchar(4000) and when loading it, I selected records where the length of definition was <=...