I know I'm late adding this Barry, but I have to admit that I was right. During The Rant, Steve sent me a PM asking me to write an...

I have to agree. I don't consider MDX to be a part of T-SQL. T-SQL is used to query MS SQL Server databases. Last I knew, MDX...

When you are talking about a raw file, are you talking about a raw file also created by SSIS or are you talking about a flat file, like a CSV...

dbishop (4/14/2009)

---

Lynn Pettis (4/14/2009)

---

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

Could you post your format file so we may see it?

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