J (3/17/2009)

---

Woops! with my limited command of the Englsih language (not my mother tonge) I assumed Lynn was a...

foxjazz (3/17/2009)

---

why would any of you think that foreach(select something) impies a cursor within t-sql?

Is it because the only way we are able to do a loop in t-sql is...

I humbly apologize, I just came to the same conclusion that the repeating place holder is for adding new columns.

I'll give it a try. If it doesn't work, then I think there is a problem with the documentation. I was just reading it as they say to.

J (3/17/2009)

---

This kind of justification inevitably leads to a...

Yes, you can. I am including a partial copy of the ALTER TABLE statement from BOL:

ALTER TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name...

Lynn Pettis (3/17/2009)

---

d_walker (3/17/2009)

---

Based on several examples found here and in BOL I have the following SQL :

SUM(CASE WHEN DateDiff(d,GETDATE(),l.[Due Date]) between -31 and -60 THEN d.[Amount (LCY)] ELSE 0...

d_walker (3/17/2009)

---

Based on several examples found here and in BOL I have the following SQL :

SUM(CASE WHEN DateDiff(d,GETDATE(),l.[Due Date]) between -31 and -60 THEN d.[Amount (LCY)] ELSE 0 END) as...

Forum etiquette would have you post your resolution so...

Well, if you've checked my profile you know I live in Colorado Springs, CO. My drink of choice is Dr Pepper. Mostly the diet version, but I do...

Can you provide more information about the tables? The DDL (CREATE TABLE statments) and the indexes defined would be beneficial.

The key idea is to identify what records you want...

Michael Valentine Jones (3/16/2009)

---

I can't see why you would drop the clustered index and then recreate it, since that forces SQL Server to rebuild the table as a heap and...

You know what? We should move this conversation back to THE THREAD before we actually do have THE SON OF THREAD going. Care to join me?

I don't ride no...

Well,...