You can only run a stored procedure from INSERT INTO command. See Re: How can I know if a folder exist Message #962432 for example.

>Is there a way to execute a procedure from within a SQL select?
>Such as this sample:
>
>

>
>select
>name,
>(exec dbo.GetAccountBalance customer.AccountNumber) as AccountBalance
>From customer
>
>