I am getting an error formatting SQL with an Insert using Execute stored procedure, any ideas?

• 
  P.S. I have version 8.0.7.1917 and I think it was OK in the previous version but not 100% sure.

  PaulBP14 August 04, 2017 11:42

  - 0 +
• 
  The syntax seems correct. Let me check with the team.

  Grant August 07, 2017 12:28

  - 0 +
• 
  I get the formatter to work happily if I comment out the '--At WSLSource;' so I reckon the bug is there. It isn't your source which seems fine. I have put an entry in sys.servers for WSLSource to test this.
  GO
  
  CREATE TABLE tmpRptInvoiceHistory
  (
  BookingNo INT,
  ReportDate DATETIME
  );
  GO
  
  DECLARE @sql VARCHAR(MAX);
  
  SELECT @sql = 'Select 1,''1 Jan 2008''';
  
  INSERT INTO tmpRptInvoiceHistory(BookingNo, ReportDate) EXEC(@sql); --At WSLSource;

  Phil_Fact0r August 11, 2017 13:45

  - 0 +
• 
  Thanks Phil, so is this a bug in SQL Prompt?

  PaulBP14 August 11, 2017 14:33

  - 0 +
• 
  Hi @PaulBP14,
  
  This does appear to be a bug which I've logged as SP-6583.
  
  Thanks for pointing this out! I'll post here once we have an update.

  Jessica R August 25, 2017 16:58

  - 0 +

Add comment

Please sign in to leave a comment.