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

Got it. I had to do the execute, not parse that I was running before.

Thank you, again, for your help.
Beth