title: Split 1 row into 2 rows with % of total
body: <pre><code>create table #testdata
  (
      ID int,
      Total money
  )
  
  insert into #testdata
  (
      ID,
      Total
  )
  select
      1,
      100
  union all
  select
      2,
      105
  union all
  select
      3,
      110
  union all
  select
      4,
      150
  
  
  select * from #testdata
  </code></pre>
  <p>How can I convert each row into 2 rows, the first row having 75% of the total, and the other row being 25% of the total where I can also then include other columns?</p>