title: How do I insert the output of these loops into my table?
body: <pre><code>Declare @PASS char(16)
  
  Declare @COUNTER int
  
  SET @COUNTER = 0
  
  While @COUNTER &lt; 2
  
  begin
  
      select @PASS =replace
                    (replace
                       (replace
                          (replace
                             (replace(
                                (select substring(@String, 1 + Number, 1) 
                                 from master..spt_values
                                 where number &lt; datalength(@String)
                                 order by NEWID()
                                 for xml path('') 
                                ), '&lt;', '&lt;')
                             ,'&gt;','&gt;')
                          ,'&amp;','&amp;')
                       ,'"','''''')
                    ,'&amp;apos','''')
     select @pass
     set @counter = @counter + 1
  
  end
  </code></pre>