Hello all,
I have a rather urgent question regarding how to select from multiple tables using MAX and Count()
Table1 has a simple period_id
period_id
1
2
3
4
5
etc...
Table2 conta...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23201641.html
Can anyone help me in writing a SQL query which takes values from the list box and inserts into a database table.The only complication in this is
The number of items in the listbox may not be eq...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23242819.html
I need to write a SQL Select Statement which takes columns from another select command
For example
Select (select * from tblabc where customerid =100) from tblmaster.
Thank You
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23247497.html
Hi experts:
I got the following table:
MU CT Date SO1 SO2 S03 S04 S05 S06
100 12 6/6/08 1 2 3 4 5 6
100 10 6/6/08 1 2 3 4 5 6
200 14 6/7/08 1 2 ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2346...
I want to turn/rotate certain information that are displayed in joined rows, so they will become extra columns in the query output.
To illustrate this problem, I have set up an example in which ...
http://www.experts-exchange.com/Database/SQLBase/Q_23807469.html
My vb.net app has been working for many months and all of a sudden i am getting a timeout message when trying to do an SQL update from my code. If i run from the MSSQL window i can add manually fin...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23781757.htm...
I have created a DTS Package in SQL 2005 . The package is regarding importing data from a text file into excel.I works fine. But now I want to add the DTS package in VB.NET in a form on a command b...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_23802131.html
Hi
i need an expert advice for how to create parent child relation between to tables so that the parent table will display the child table when i click plus sign. i need to to see the chid table...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2316...
Hi
im getting Unhandled Cast Exception while adding a new data source: The error message says:
Error Message: Unable to cast object of type 'System.Diagnostics.DebuggerNonUserCodeAttribute' to...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23194019.htm...
I need to do update two tables from one save button on a Win form.
I understand I cannot update two tables in one query.
I understand I must use two updates.
I do not know HOW to do two update...
http://www.experts-exchange.com/Microsoft/Development/.NET/Q_23315755.html
