Timeline for Receiving error while creating stored procedure to insert Excel files into a table
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 29, 2018 at 14:33 | vote | accept | CommunityBot | ||
| S Sep 29, 2018 at 11:40 | history | suggested | Glorfindel | CC BY-SA 4.0 |
formatting
|
| Sep 29, 2018 at 9:56 | comment | added | user157749 | DECLARE @Bufr nvarchar(4000) --SET @Bufr='delete from '+@TableName+';' SET @Bufr='insert into '+@TableName + 'EXEC(@RetValue) ' EXEC (@Bufr) we have to change it this way . but this one won't work either !!! you know.. the insert part won't be executed we have to solve this issue | |
| Sep 29, 2018 at 9:45 | comment | added | user157749 | thank you very much . the problem is that I can see the results but not in the destination table. would you mind if you test it yourself ? I can see the result of the procedure but the data won't be inserted into the destination table. | |
| Sep 29, 2018 at 9:40 | review | Suggested edits | |||
| S Sep 29, 2018 at 11:40 | |||||
| Sep 29, 2018 at 9:37 | vote | accept | CommunityBot | ||
| Sep 29, 2018 at 9:43 | |||||
| Sep 29, 2018 at 9:00 | review | First posts | |||
| Sep 29, 2018 at 9:41 | |||||
| Sep 29, 2018 at 8:57 | history | answered | user2634333 | CC BY-SA 4.0 |