hiim new to t-sql what would be the best way to write this.any help would be great select all Columns , the sum of “Value” as TOTVAL and the sum of UNValue as TOTUNVAL and the sum of “Shares” as TotShrs From the second dataload and place into “Futures” table Group the results by their “Fund”,”CUSIP” and “Pos_typ” So long as the list contains 70-75 order the results by their “fund” and “CUSIP” Select the “futures” and replace the Value column with TotVal Replace Unval with TotUnVale Replace Shares with TotShares in the futures tableSelect the “futures” Replace all the CUSIPs on futures with a pos_typ of “S” Select the second dataload Delete all in the list that are between 70 and 75 Select the second dataload Append the selected data to the futures table End the process and rollup the futures