So we'll have a SelectPens function and associated proc to bring back all
pens to the client. Now think about all the variations that might be needed
(many). For example, to show the pen feed sequence I'll need a subset of
fields and ordered by FeedSequence.
Option 1) I've seen some shops where they have a function (and associated
proc) for every slice and dice.
Option 2) I've seen some shops where they have a function for every slice
and dice, but then just use the one stpSelectPens proc (they then slice and
dice it in the business layer before returning to the client)
Option 3) I've seen some shops where they have a single function and proc
(stpSelectPens) and then the client can slice and dice all it wants to
present to the user
I'm leaning toward option 3. Any other opinions?
Thanks,
Ron