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?