CREATE TABLE DetailedSales (TransId INTEGER, RegionId INTEGER, SalesAmt DECIMIAL(38,2))
                
CRETE TABLE RankSalesByRegion (RegionId INTEGER, TotalSales DECIMAL(38,2), RegionRank INTEGER)

public void ManipulateLargeDecimal(TdConnection cn)
{
    // creating commands that will be used to execute SQL statements
    TdCommand cmd1 = cn.CreateCommand();
    TdCommand cmd2 = cn.CreateCommand();
 
    // query to rank the sales by region
    cmd1.CommandText = "select RegionId, TotalSales, Rank(TotalSales) " +
       "from (select RegionId, sum(SalesAmt) as TotalSales " +
               "from DetailedSales group by RegionId) as SalesByRegion";
   
    TdDataReader reader = cmd1.ExecuteReader();
 
    // setting up command that will insert rows returned from query into
    // the RankSalesByRegion table
    cmd2.CommandText = "insert into RankSalesByRegion (RegionId, " +
       "TotalSales, RegionRank) values (?, ?, ?)";
       
    cmd2.Parameters.Add(null, TdType.BigInt, 0, 
       System.Data.ParameterDirection.Input, 
       true, 0, 0, null, System.Data.DataRowVersion.Default, null);
       
    cmd2.Parameters.Add(null, TdType.Decimal, 0, 
       System.Data.ParameterDirection.Input, 
       true, 38, 2, null, System.Data.DataRowVersion.Default, null);
       
    cmd2.Parameters.Add(null, TdType.Integer, 0, 
       System.Data.ParameterDirection.Input,
       true, 0, 0, null, System.Data.DataRowVersion.Default, null);
 
    // TdDecimal sumOfSales = new TdDecimal(0);
    // could also have been used
    TdDecimal sumOfSales = 0;
    TdDecimal avgSalesByRegion = 0;
 
    // Loop through the result set:
    //   Read data returned, and set the Value property of the corresponding
    //   TdParameter with the data returned for each column.
    while (true == reader.Read())
    {
        // Reading a BIGINT and
        // Setting the RegionId parameter
        cmd2.Parameters[0].Value = reader.GetInt64(0);
 
        // Reading a Large Decimal and
        // Setting the TotalSales parameter
        cmd2.Parameters[1].Value = reader.GetTdDecimal(1);
 
        // Seting the RegionRank parameter
        cmd2.Parameters[2].Value = reader.GetInt32(2);
 
        // Summing up on the total sales
        sumOfSales += (TdDecimal)(cmd2.Parameters[1].Value);
 
        cmd2.ExecuteNonQuery();
    }
 
    // Calculating the avg sales by region
    // The reader.RecordsReturned is explicitly converted to TdDecimal
    avgSalesByRegion = sumOfSales / (TdDecimal)(reader.RecordsReturned);
 
    reader.Close();
 
    cmd1.Dispose();
    cmd2.Dispose();
}

public void CalculateSalesForRegion(TdConnection cn, Int32 RegionId)
{
    // Creating commands that will be used to execute SQL statements
    TdCommand cmd1 = cn.CreateCommand();
 
    // The CalculateSalesForRegion stored procedure has the 
    // following parameters:
    //     in RegionId Integer
    //     out Rank    Integer
    //     out SalesForRegion Decimal(38, 2)
    //     out PercentOfTotalSales Decimal(7, 4)
    cmd1.CommandText = "CaculateSalesForRegion";
    cmd1.CommandType = System.Data.CommandType.StoredProcedure;
   
    // Setting up parameters to return sales information for the 
    // specified region
    // 
    // Parameter for the RegionId
    Cmd1.Parameters.Add(null, TdType.Integer, 0, 
       System.Data.ParameterDirection.Input, 
       true, 0, 0, null, System.Data.DataRowVersion.Default, RegionId);
 
    // Parameter for the Rank
    cmd1.Parameters.Add(null, TdType.Integer, 0, 
       System.Data.ParameterDirection.Output, 
       true, 0, 0, null, System.Data.DataRowVersion.Default, null);
 
    // Parameter for the SalesForRegion
    cmd1.Parameters.Add(null, TdType.Decimal, 0, 
       System.Data.ParameterDirection.Output,
       true, 38, 2, null, System.Data.DataRowVersion.Default, null);
 
    // Parameter for the PercentOfTotalSales
    cmd1.Parameters.Add(null, TdType.Decimal, 0, 
       System.Data.ParameterDirection.Output,
       true, 7, 4, null, System.Data.DataRowVersion.Default, null);
 
    // Execute the Stored Procedure
    cmd1.ExecuteNonQuery();
 
    // Retrieve the data for each of the out parameters
   
    // Getting the data returned for the Rank
    Int32 rank = cmd1.Parameters[1].Value;
 
    // Getting the data returned for the SalesForRegion
    //    In the instance this parameter was defined as a 
    //    DECIMAL(38,2).  If the TdParameter.Value property is
    //    accessed an OverFlowException will be thrown.
    TdDecimal salesForRegion = cmd1.Parameters[2].ProviderSpecificValue;
 
    // Getting the data returned for the PercentOfTotalSales
    //    Since the parameter is defined as a Decimal(7,4) an
    //    application can either retrieve the data using the
    //    TdParameter.ProviderSpecificValue or TdParameter.Value property.  
    //    ProviderSpecificValue will contain a TdDecimal structure. 
    //    Value will contains a System.Decimal structure.
    TdDecimal tdPercentOfTotalSales = cmdl.Parameters[3].TdValue;
    System.Decimal sysPercentOfTotalSales = cmd1.Parameters[3].Value;
 
    //
    // CONTINUE PROCESSING THE DATA RETURNED FROM THE STORED PROCEDURE
    //
 
    cmd1.Dispose();
}