question

I was discussing with a senior colleague of mine about a design technique existing for a stored procedure. Here is a sample of it - USE [Alpha] GO ALTER PROCEDURE spCalculations ( @AccountID INT, @Rate FLOAT, @EffectiveDate DATE -- Few other variables ) AS BEGIN -- Creation of #TempData code here -- Non Clustered Indexing of columns of #TempData code here /** Current Technique to insert data** Declare @CmdString1 varchar(2000) Declare @CmdString2 varchar(2000) Set @CmdString1 = 'execute [Omega].dbo.spLINK_GetData' Set @CmdString1 = @CmdString1 + convert(varchar(15), @AccountID) + ', ' Set @CmdString1 = @CmdString1 + convert(varchar(15), @Rate) + ', ' Set @CmdString1 = @CmdString1 + convert(varchar(15), @EffectiveDate) Set @CmdString2 = ' INSERT INTO #TempData ( AccountID, Rate, EffectiveDate ) Select * From OPENQUERY (MasterLinkedServer, ''' + @CmdString1 + ''') ' EXEC (@CmdString2) **/ /** My proposed Technique towards Insertion ***/ INSERT INTO #TempData ( AccountID, Rate, EffectiveDate ) EXEC MasterLinkedServer.[Omega].dbo.spLINK_GetData @AccountID, @Rate, @EffectiveDate -- Other logic for the procedure continues... END GO My colleague retorted that with my proposed technique, there is a possibility that you will end up with "INSERT EXEC SQL Exception" since spCalculations procedure is called again and again from one of its child procedure in a loop. Can anyone please help me in understanding in detail what do we mean by the INSERT EXEC SQL Exception?