How would you convert the following SQL Statement into a stored procedure using passed in parameters with SQL Server 2008?
Posted on 2016-10-07
How would you convert the following SQL Statement into a stored procedure in SQL Server 2008?
The fields starting with "str" would be passed in as parameters:
INSERT into dbo.tbl_CSL_ImportMonthlyChecks (bankname, amt1, banknumber, amt2, datefile, dateimported, importedby)
VALUES ((SELECT bankDescr from dbo.tbl_CSL_Bank WHERE bankID = strBank), strAmt1, strBank, strAmt2, strFiledate, strImportdate, strImportby);