C#

const string pattern = @"_(?<FileCode>([^_][a-zA-Z0-9])+)\.txt$";
const string text = @"Directory\Subdirectory\Subdir\Subsubdir\sub_sub_subv009\filename_with_lots_of_ABC123.txt";

var groupFileCode = Regex.Match(text, pattern);

Console.WriteLine(groupFileCode.Groups["FileCode"].Value);

// alternatively without regullar expressions
int lastUnderscoreIndex = text.LastIndexOf('_');
int lastPointIndex = text.LastIndexOf('.');

Console.WriteLine(text.Substring(lastUnderscoreIndex + 1, lastPointIndex - lastUnderscoreIndex - 1));

CREATE PROCEDURE dbo.Foo
  @StateCode AS CHAR(2),
  @OutVariable1 AS INT OUTPUT,
  @OutVariable2 AS INT OUTPUT
AS
BEGIN
  SET @OutVariable1 = 100
  SET @OutVariable2 = 150

  SELECT * FROM dbo.Persons WHERE State = @StateCode
END

string stateCode = "AL";
int outValue1 = 0;
int outValue2 = 0;

using (SqlConnection = new SqlConnection(connectionString)) {
    using (SqlCommand cmd = new SqlCommand("dbo.Foo") ) {
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Paramaters.Add("@StateCode", SqlDbType.Char, 2) = stateCode;
        SqlParameter outValue1Param = cmd.Parameters.Add("@OutVariable1", SqlDbType.Int);
        SqlParameter outValue2Param = cmd.Parameters.Add("@OutVariable2", SqlDbType.Int);

        // Get Result Set
        using (DataReader dr = cmd.ExecuteReader()) {
            while ( dr.Read() ) {
                // Read datareader value
            }
        }

        // Get output values
        outValue1 = (int) outValue1Param.Value;
        outValue2 = (int) outValue2Param.Value;
    }
}

}<br />
<br />
Is there another way to do this?  Tried looking into a foreach loop, but that would not work.<br />
<br />
Thank you!!!

using ( SqlDataReader dr = cmd.executeReader() ) {
  while ( dr.Read() ) {
    // Read all row values here
  }
}

// Now you can read the output value
int ouputValue = (int) outParam.Value;

SqlDataReader dr = cmd.ExecuteReader();

while ( dr.Read() ) {
  // Read all row values here
}
dr.Close();

// Now you can read the output value
int ouputValue = (int) outParam.Value;