title: Insert into table from another table after sorting data of first table
body: <p>I am doing something like this in SP,</p>
  
  <pre><code>insert into @FilteredTbl select * from @MasterTbl
  </code></pre>
  
  <p>but now problem is that i want data of @MasterTbl sorted before adding into @FilteredTbl,</p>
  
  <p>How can I do that ?</p>