Sql Server Insert Into table with values stored proc output with other values <p>Say there is a table</p> <pre><code>CREATE TABLE [Fruit]( [FruitId] [int] NOT NULL Identity(1,1), [Name] [nvarchar](255) NOT NULL, [Description] [nvarchar] (255) NOT NULL, [Param1] [int] NULL, [Param2] [int] NULL) </code></pre> <p>and stored proc where it takes an input and has an output parameter called @description. I cannot modify this stored proc.</p> <pre><code>EXECUTE usp_GetFruitDescription @Name, @Description OUTPUT </code></pre> <p>Now I want to do insert into the [Fruit] table, something like the following.</p> <pre><code>INSERT INTO [Fruit] Values( basket.Name ,EXECUTE usp_GetFruitDescription basket.Name ,basket.Param1 ,basket.Param2) FROM [FruitBasketEntry] basket WHERE basket.type is not null and basket.id &gt; 6 </code></pre> <p>How can this be achieved? I've seen examples of INSERT INTO [table] EXECUTE usp_proc, but I haven't seen it with inserting with other values not from stored proc output. Thanks!</p>