View Complete Post
I have my data in excel like this ....
public static string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";
OleDbDataAdapter adapter = new OleDbDataAdapter();
OleDbCommand selectCommand = new OleDbCommand("SELECT * FROM [Sheet1$]");
OleDbConnection connection = new OleDbConnection(connectionString);
selectCommand.Connection = connection;
adapter.SelectCommand = selectCommand;
DataSet cities = new DataSet();
I have two SQL tables (SQL 2005) that I need to join but am in need of some
assistance. Essentially I need to join a column name with row field values.
The first table contains the following columns
The second table contains the following columns
However, the rows in the second table for the Ord column contain
the following values:
I need to join the row field value of the second table with
the column name of the first table. I want to display the values of the respsective columns of table one (Ord_SignedApp, Ord_Title, Ord_Reg, Ord_Name) and place them in a new column. These values are represented as dates
Any assistance you can provide would be much appreciated.
Thank you for your help,
Hi, I have two tables, CUSTOMER and PAYMENT_DETAILS. I need to extract "name" and "phone" from CUSTOMER table and TOP 2 payments for matching email from PAYMENT_DETAILS table. Kindly refer to the attached image for table structure and
when we compare IN,EXISTS or INNER JOIN with performance wise which one is the best? Any Example to prove it?
I have a select query which is executing well. Now, I want to add one more field to that query. That field is not in the current query table, It is in the another table.
How do I join those two tables and get that field value in the existing select query.?