At one time I created a very inelegant solution using Tempdb. Where I had to select all the ID's and stuff them in a temp table. Then I selected the...