Hi,
Just wondering if anyone can help with a SQL Server 7 Stored Procedure
question.
I have a stored procedure that returns a group of fields from a table. What
I'd like to do is return a field which is the result of another stored
procedure that does something to one of the fields from the table.... For
Example....
Select TheId,
TheDate,
NewConvertedDate = (Execute storedprocedure TheTable.TheDate)
FROM TheTable
I know that I can nest stored procedures in other stored procs, however, I
can't seem to find the right syntax (if it's possible) to return the result
of a stored procedure as another field in the same select.
Is this possible? Can anyone help with the syntax?
Thanks
Nick
------------------------------------------------------------------------------
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.