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 .

http://www.microsoft.com/sql/msde/downloads/default.asp

Let me put it this way... I have 3000+ hours experience with sql/sqlserver and I'm just starting to feel comfortable.

This is not something you can learn by yourself... You need...

Sorry, should have asked this earlier.

This is something that you do NOT keep in the db since it can be calculated easyly.

Select Production, dateadd(m, -6, Production) as Before, dateadd(m, +6,...