Nesting Stored Procedure

hi I have another question to ever so helpful forum


I am trying to nest stored procedure but I guess it is not the way to do it as it does not work:





CREATE PROCEDURE dbo.GetSharesTransactionsbyDates





(


@Startdate as char(10),


@Enddate as char(10)





)





AS





dbo.GetSharesTransactionsData /*tryting to nest sproc*/


WHERE TRANS_DATE BETWEEN @Startdate and @Enddate





I get complain that dbo is incorrect syntax








ST.Proc. which I try to call call is basicly a select statement with no parameters:





ALTER PROCEDURE dbo.GetSharesTransactionsData


AS


SELECT TRANS_DATE, TYPE_DESCRIPTION, SHARE_SYMBOL, SHARES_QUANTITY,


ROUND(PRICE_PER_SHARE,2) AS PRICE_PER_SHARE, COMMISSION_VALUE,


STAMP_DUTY,


dbo.GetShareTransactionTotalValue(PRICE_PER_SHARE,STAMP_DUTY,COMMISSION_VALUE,


SHARES_QUANTITY,CASH_AMOUNT, TYPE_DESCRIPTION) AS TOTAL_VALUE,/*calling function*/


ACCOUNT_NAME


FROM SHARES_TRANSACTIONS


WHERE (TYPE_DESCRIPTION = 'Sell') OR


(TYPE_DESCRIPTION = 'Buy') OR


(TYPE_DESCRIPTION = 'Cash Divident')


ORDER BY TRANS_DATE