How can we help you today? How can we help you today?
brucekillam
Activity overview Badges (0) Posts (3) Comments (2)

Comments

Sort by recent activity
Yes, this seems be the problem and if you could add a link to this thread to the bug report, that would be much appreciated. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Generated script for Triggers
Yes, this seems be the problem and if you could add a link to this thread to the bug report, that would be much appreciated.
0 votes
Without applying my workaround, if I put the cursor to the left of the * and try to force the candidate list with CTRL+SPACE it offers no suggestions. An example of this would be the following query (run from the ReportServer db): SELECT * FROM [ReportSchedule] P10tbl JOIN [Catalog] R17fk ON P10tbl.ReportID = R17fk.ItemID JOIN [Subscriptions] R18fk ON P10tbl.SubscriptionID = R18fk.SubscriptionID JOIN [Schedule] R19fk ON P10tbl.ScheduleID = R19fk.ScheduleID Copy from the first character of the query to the last and paste it into a new query window (I'm using SSMS) and put the cursor after the * and hit tab. What I get is the following (notice that it only gives columns for the first two tables - P10tbl and R17fk; R18fk and R19fk seem to be ignored): SELECT P10tbl.[ScheduleID], P10tbl.[ReportID], P10tbl.[SubscriptionID], P10tbl.[ReportAction], R17fk.[ItemID], R17fk.[Path], R17fk.[Name], R17fk.[ParentID], R17fk.[Type], R17fk.[Content], R17fk.[Intermediate], R17fk.[SnapshotDataID], R17fk.[LinkSourceID], R17fk.[Property], R17fk.[Description], R17fk.[Hidden], R17fk.[CreatedByID], R17fk.[CreationDate], R17fk.[ModifiedByID], R17fk.[ModifiedDate], R17fk.[MimeType], R17fk.[SnapshotLimit], R17fk.[Parameter], R17fk.[PolicyID], R17fk.[PolicyRoot], R17fk.[ExecutionFlag], R17fk.[ExecutionTime] FROM [ReportSchedule] P10tbl JOIN [Catalog] R17fk ON P10tbl.ReportID = R17fk.ItemID JOIN [Subscriptions] R18fk ON P10tbl.SubscriptionID = R18fk.SubscriptionID JOIN [Schedule] R19fk ON P10tbl.ScheduleID = R19fk.ScheduleID / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Expand SELECT *
Without applying my workaround, if I put the cursor to the left of the * and try to force the candidate list with CTRL+SPACE it offers no suggestions. An example of this would be the following quer...
0 votes
Total activity
7
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2