I'm definitely not going to argue with you Gail, but wouldn't horizontal partitioning with a Sliding Window be an option to consider?

To be more specific:

If the business case would allow...

We still do.

The issue with VARCHAR(MAX): it's a Large Object Data Type, which is a special data type...

something like where abc in (5, 6)

OR (abc in (1, 2, 3, 4) AND cde in (123, 452, 78, 124, 458))

You might want to try the original QUEST site. There's a FAQ as well as a forum (IIRC).

duplicate post. no replies please.

original post can be found here

Steve Jones - SSC Editor (7/8/2011)

---

WayneS (7/8/2011)

---

Steve Jones - SSC Editor (7/8/2011)

---

TGIF

Actually not so much. Leaving for the UK on Sunday, will be out of touch for most of the...

duplicate post. No replies please.

Original post can be found here

To repeat what I stated earlier:

It seems like the indexes available can't be used in the first statement since the indexes are not covering indexes (e.g. an index for table2...

but where do I draw the line? 20? 50? 100? Inevitably, someone will want 101 or 102. Putting a firm number seems to me to indicate some real, defined limit....

kramaswamy (7/8/2011)

---

you basically thinking something along the lines of

INSERT INTO TABLE1 (Columns)

OUTPUT INSERTED.ID INTO #TempTable

SELECT FROM InputRecordSet

INSERT INTO TABLE2 (Columns)

SELECT ID...

Since you're using SS2K5 (as indicated by the forum you posted in) I'd recommend to look into the OUTPUT clause of the INSERT statement. It's much more reliable than the...

I'd start at the very beginning:

The massive use of VARCHAR(MAX) seems to be oversized from my point of view. Not only within the functions, but also within the table structure:

Example:...

Since this is a rather strange requirement, may I ask if this is ome kind of homework?

Anyhow, you'll need a table (or subquery or CTE) with all character values you'd...

It seems like the indexes available can't be used in the first statement since the indexes are not covering indexes (e.g. an index for table2 should not only include the...

Please post table def for the tables invloved together with some sample data in a ready to use format as described in the first link in my signature.

Please include your...