sql server stored procedure - lookups & variables
Posted on 2011-09-06
I need to create a stored procedure in the following format:
INSERT INTO dbo.Table(
--- But ---
Row1 for example might require a lookup from another database table.
How would I do the lookup so that the returned value could be inserted
into the table?