There has to be a better way!
When writing a subquery code I need all the rows listed from a table so I can manipulate what I want grouped/summed/etc. The only way I have found to do this is to find that table in the SQL Object Explorer, right click, and hit ‘Select Top 1000 Rows’, then copying and pasting into my subquery.
Isn’t there a shortcut or something so I don’t have to get out of my query to do that? Why can’t I select the table and right click or something.
Please someone tell me there is a better way!!