StringBuilder sb = new StringBuilder();
sb.Append("SELECT *");
sb.AppendFormat(" FROM {0}",YourTableName);
sb.AppendFormat(" WHERE cName LIKE '{0}%'", WorkGroup);
sb.AppendFormat(" AND dIntervalStart >= '{0}' AND dIntervalStart < '{1}'", StartDate, EndDate);
sb.Append(" GROUP BY cName");
string sql = sb.ToString();
            
SqlConnection cn = new SqlConnection(SqlDataSource);
SqlCommand cm = new SqlCommand(sql, cn);