RE: Syntax Help for Stored Procedure

[allyne]

Hi everyone,

I have an Access Database that I am Upgrading to SQL 7.0. In the Access Database There is a form that has a drop down box where the user can select a Switch Id. Once Selected the next step is to Select Bid from another drop down box. Once this is done the user then clicks on a button that updates the selected values from the drop down boxes and inserts it into a table. The Syntax used in the Access Database is:

INSERT INTO [tblSwitcId/Bid] ( SID_BID, SwitchId, BridgeText )
SELECT tblMasterInOut.SID_BID, tblNetworkElements.SwitchId, [Forms]![frmBridgeSelection]![cobBid] & "-" & [Forms]![frmBridgeSelection]![cobSwitchID] AS BridgeText
FROM tblMasterInOut, tblNetworkElements
WHERE (((tblMasterInOut.SID_BID)=[Forms]![frmBridgeSelection]![cobBid]) AND ((tblNetworkElements.SwitchId)=[Forms]![frmBridgeSelection]![cobSwitchID]));

The problem is this won't work in a stored procedure. Can someone tell me what the currect syntax is in SQL 7.0.

Thanks for all your help as I'm totally stumped!

Cathy