Using an alias with an update does not show suggestions

• 
  Thanks for your post.
  
  I was trying to replicate the issue with reference to the query you have posted above.
  
  I found some issues with the alias you used dbo.Audit_Suppliers cas and the alias in Join condition as.StagingID do not match.
  
  Could you kindly elaborate more on this issue along with the query?

  Anu D August 18, 2009 09:10

  - 0 +
• 

  Anu Deshpande wrote:

  Thanks for your post.
  
  I was trying to replicate the issue with reference to the query you have posted above.
  
  I found some issues with the alias you used dbo.Audit_Suppliers cas and the alias in Join condition as.StagingID do not match.
  
  Could you kindly elaborate more on this issue along with the query?

  
  Sorry, changed a table name and thus the alias for the post. Basically, for any update query that invloves an alias, SQL Prompt is not providing suggestions. Another sample is provided below. Again, if I type the alias and the period after it, i would expect suggested columns to come up. nothing happens. This worked in version 3.x, so not sure if is a setting or a bug. My setting are pretty much default.
  
  UPDATE mi
  SET mi.input_item_records = ii.records,
  FROM #mi mi
  JOIN ( SELECT mid ,
  COUNT(*) AS records
  FROM #ii
  GROUP BY mid
  ) ii ON mi.MID = ii.MID

  sbenson August 18, 2009 09:22

  - 0 +
• 
  Thanks for your input.
  
  I have logged this in our internal tracking system whose id is SP-2730, so that it can be considered in our future releases.
  
  I will update you as soon as the bug is fixed.
  
  Many thnaks for your patience with this issue.

  Anu D August 18, 2009 10:51

  - 0 +

Add comment

Please sign in to leave a comment.