>>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

Right Click on "Stored Procedures" node in the treeview and select Refresh from the menu.