>As I said, this is something really stupid (no offense here) I did such mistakes the time.
>You miss the last END for the stored procedure:
>

>CREATE PROCEDURE bpsp_fillbuspass
>AS
>  BEGIN
>      --- Huge code here
>
>  END -- That is missing
>

>
>And there is no need to create temp table before SP :-)

Hi Borislav,

The END fixed the problem. But I can not find the SP in the listing for my database. Where should it appear if built?

Thanks for you help.
Beth