Can't really help you then.. I don't really know my way around that wizard.

can you post the whole proc... maybe we can simplify it somehow.

We all started somewhere... near the bottom .

Don't worry about it... Farrell's gonne come around one of these days .

what statement did you use?

Cool.

There's no need for dynamic sql in this situation... I'm just waiting for the answer to demonstrate .

Don't worry about that... stil got plenty of room left to pass through the door.

That's the whole point of the community .

This probabely doesn't work... but it may give you an idea.

Select dtWorks.L, Max(dtWorks.R) as work_ord_num, work_ord_line_num, bag_num

FROM

(

SELECT LEFT(work_ord_num, 6) as L, Right(work_ord_num, 2) as R,...

it didn't work.

I feel I must mention this one too :

SET SHOWPLAN_ALL

(gets the whole set of stats)

NP... the simpler the better .

Do you need to select the max id from a dynamic sampling of the table?

Glad to see someone's using my stuff once in a while .