title: SQL change the searched query based on a multiple result set
body: <p>I'm stuck, I would like to query based on multiple results, and loop until there are no more results..</p>
  
  <pre><code>USE Production
  DECLARE @job VARCHAR(10)
  DECLARE @drawing VARCHAR(10)
  
  SELECT @job = job.job , @drawing = job.Drawing
  FROM Production.dbo.Job 
  WHERE Job = 'T361322'
  PRINT @job
  PRINT @Drawing
  </code></pre>
  
  <p>The results I get are the T361322 and then the drawing, which I want to move to the job search to find other drawings until there are no further results.
  so use Set?</p>