Well that's just what I was going to say:) However, a viral infection in my throat made me miss work. Thanks Seth.

Try this

CREATE VIEW MAX_EXPIRATION AS

SELECT

t1.ID,

t1.MaxExpirationDate,

m.MemberGroup

FROM member m,

...

Ok, I'm fairly certain its the NOT IN clause that is the hog. Mainly because it shows the code in the hover box that pops up in the execution...

Try this

http://www.sqlservercentral.com/articles/T-SQL/63681/

It should answer most of your questions.

Jeff, I lost quite a few brain cells on this one, as it was just a bit over my head, and would be interested to see your solution, using...

It seems like...

Why can't you run the parts of the procedure up to the point the temp table is created and populated, then do a SELECT * from the temp table?

I think they need to start a section for 'Best humor of the day', or maybe month. I gotta say, I'm not sure where I laughed harder...at this post,...

Seth, I was rolling laughing at that. I'm a huge Dilbert fan, so any time I see 'Gah', it elicits strong images of Dilbert struggling against...

juergen, this will give you what you want based on your sample data.

SELECT

from_idnr = MIN(idnr),

to_idnr = MAX(idnr),

...

Shree, I tried a direct copy and paste of your code, commented out the WHERE clause, and the result was as follows:

ABC12344

DEF45677

GHI89010

When you say "print", what exactly do you mean?...

Try ISNULL(S.Sales,0) in the SELECT.

Check out 'Expanding hierarchies' in Books Online. If you mess around with the example you might have...

Seth

Thank you so much for the time and thought you put into this. I tested it against a production table, and it purred like a kitten. It never...

Jeff Moden (10/28/2008)

---

Greg Snidow (10/28/2008)

---

I know this is a SQL forum, but there are times when I, and this is just me, find it easier to do this kind of...