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