IS this possbile?

From: Stephen Rybacki <smrybacki_at_yahoo.com>
Date: 4 May 2004 14:30:53 -0700
Message-ID: <e42a4c34.0405041330.48797b16@posting.google.com>

I currently have a stored proc that uses a cursor that I would like to replace with a different (and hopefully faster solution). The problem is that what I need seems to be impossible to come up with without a cursor. What I really need is for one of the fields in an initial data put to contain the results of another data pull based on fields in the first pull. For example:

ID        PartID      PackingSlipNumber   <OTHER FIELDS>    Locations
=====     ====        ============        ===========       ==========
0001      ABC         PS1                 Other data        * See
Below
0001      XYZ         PS1                 Other data        * See

Below

• This field I would like to retireive a count of all locations where the part/packing slip combo already exists

So what I have is a Pallet that has from 1 to many parts (detail lines) on it. Each part has a packing slip associated with it and part/packing slip combos cannot be split among warehouse door locations. So the total locations field would then be chacked for 0 or 1 as a value to be considered "OK".

This is actually hard to describe, but if anyone has any ideas how I can do this sort of thing without a cursor, I'd surely appreciate it.

TIA, Steve Received on Tue May 04 2004 - 16:30:53 CDT