Hi Chris,

I had to add a quick index on acct_no to get the table scale-up thing to work in my lifetime (the MAX gets out of hand without it!), but...

Very nice. I seem to recall that there is...

Some code to illustrate my point:

DECLARE @Result

TABLE (

enrollee_id INTEGER NOT NULL,

...

The reason for TYPE and the XQuery outside is to solve entitization issues.

Try including sample data embedded characters such as '&', '<', '>' (and so on)...you'll...

Matt Miller (#4) (2/22/2010)

---

WayneS (2/22/2010)

---

If you use sp_executesql, the dynamic string can be set up so that all variables are parameters, and the parameters also passed in thru sp_executesql. As...

If you wanted to list all products which have all descriptors, you might use something like this:

DECLARE @product

TABLE (

product_id ...

-- Table 1

DECLARE @T1

TABLE (A INT NOT NULL);

-- Table 2

DECLARE @T2

TABLE (A INT NOT NULL);

-- Sample data for table 1

INSERT @T1 (A) VALUES (1);

INSERT ...

I had noticed that too, but thought 'Welsh Corgi' had improved in that...

I said "don't be a...

For completeness, I'm going to add a new method to the mix (before anyone else jumps in!).

This is a method called 'set-based iteration' by MVP Hugo Kornelis, which was first...

I am just a mess of giggles here...:laugh: :laugh:...

LMAO! :laugh:

Do you mean: You want to...

Jeff,

Did you really just post:

...? Have you...

Kingston Dhasian (2/26/2010)

---

In fairness, it is *a* solution, just probably not optimal :laugh: