Stored Procedure Help

[Nick Slay]

Now the list appears to be operational again, I'll try and throw this back 
out and see if anyone has any ideas!  :^)

I have a small stored procedure (do_something) that takes a parameter, adds 
a value to it, and then returns a value, straight forward enough, right.... 
but what I'd like to do is to call that stored procedure to derive a field 
that is returned in another stored procedure... for example:

SELECT  aTable.TableId,
                aTable.theValue,
                (exec do_something aTable.theValue) AS theResult
FROM    aTable

I'm not even sure if this can be done, but if it can, does anyone have any 
idea of the correct syntax?

Thanks

N

------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.