what does procedure sp_GetRecord return? if its returning resultset (row of values) how can you store in a variable. In that its better to create a temporary table having same structure as resultset and dump results to it usingINSERT INTO #TempEXEC sp_GetRecord 'cp19014147808'
alternatively if it returns a single value make an output parameter in your sp and you it to return the value.DECLARE @Returnvalue <datatype>EXEC sp_GetRecord 'cp19014147808',@Returnvalue OUT