You likely have not gotten any responses to your question because you didn't post enough information. In order to help we will need a few things:

1. Sample DDL in the...

Igor Micev (3/14/2014)

---

Luis Cazares (3/14/2014)

---

Not...

andrexcobar (3/14/2014)

---

Sean Lange (3/14/2014)

---

Well you first example was using a parameter. Not sure what you mean by an array of strings. How do you get this into sql?

You seem to...

Well you first example was using a parameter. Not sure what you mean by an array of strings. How do you get this into sql?

You seem to be jumping back...

So you want the startdate for the first row...

JP10 (3/14/2014)

---

Ok here is my other issue. Below is the sample data. What if the StartDates and EndDates were not stored in the table and were derived originally...

andrexcobar (3/14/2014)

---

Sean Lange (3/14/2014)

---

First of all I want to confirm that you are actually using sql 2000.

I can't use CTE, TEMP Tables or SPs, I have to resolve this in...

Not to worry, we were all first timers at one...

First of all I want to confirm that you are actually using sql 2000.

I can't use CTE, TEMP Tables or SPs, I have to resolve this in the SELECT query...

Thanks for the ddl and sample data. This helps make this a LOT easier.

The first thing I did was to use a cte to allow me to number the rows....

Pritz (3/14/2014)

---

Thanks, please consider this one.

I am newbee on this.

What I am trying to do is set @rec_num to 0 and then

Set @Nrec_num = @Nrec_num + 1

Set @SQLexec =...

JP10 (3/14/2014)

---

Hello,

Let's say the first row returned has StartDate = 1/1/2014 and EndDate is 1/2/2014. The next row I want the StartDate to equal the previous row EndDate so...

Mark Derryberry (3/14/2014)

---

I've run into a brain teaser (at least to me) and I'm hoping for some forum help.

Simply put, I'm trying to modify a date range, but it's much...

You can't put tempdb exclusively in ram. The size of tempdb is very...

Ahh...