I have built a solution in asp and Access but am currently using SQL Server and I am sure this could be done easier in stored procedures and was looking for suggestions.<BR><BR>I have and orderitems table joined to the orders to return order totals.<BR><BR>Then I am running a query on the prior query to select the orders with a value &#060; 3000. Next I run another query on the prior that calculates the average order value per the last twelve months.<BR><BR>With that said, I am able to do this easily in Access but am unsure how I call another procedure from within one.<BR><BR>Any input is greatly appreciated.