Hi,
I'm doing a manual table build to display some data. In the application there are several drop down menus that are used to build the sql. The results display in a decent time unless the ALL...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23093476.htm...
Hi, I am trying to run a select statement to pull back the course id for a specific user, but it's not working. Can someone look at it and see if you can tell what I'm doing wrong. The text box I'm...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23233198.htm...
Hi, I have two tables in sql server 2000 and I need to be able to get the count of a field from the nested query. This is the query I am using:
SELECT Distinct Course_FK, TotalEnrolled
FROM te...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23461875.html
Hi, chapmandew helped me develop this sql yesterday and the one he gave me works perfectly in query analyzer, but when I put it in Visual Studio it blows. I was wondering if someone could take a lo...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23463791.htm...
Hi,
I have an application where a user can select a school session from a drop down and it will give them the attendance that has not been entered for that session. I have 12 different sessions ...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23537426.htm...
Hi,
I have a survey that is basically just a static page with 14 questions. Some of them are radiobuttonlists, the others are text boxes. Anyway, I'm inserting them into the database as one reco...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23663916.htm...
Hi all,
I have the following SQL SELECT statement that calls data ina VB.NET application.
SELECT PLT_ID, PLT_CONT, PLT_STR, PLT_LENGTH, PLT_WIDTH, PLT_THICKNESS, PLT_GRADE, PLT_BUTTED, P...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23173679.html
Hi all,
I have the following code which scans through a dataset, removing any items that meet the criteria:
For Each dr As DataRow In DS_girders_quick1.GIRDER_QUICK.Rows
...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23238984.htm...
Hi all,
I have the following code which is trying to take a text file and carry out a bul insert into a SQL Server 2000 table:
Dim comm As New SqlCommand
comm.Connection = SqlC...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23266326.htm...
Hi,
I have an online survey and the results are stored in one table. I need to display the results as percentages so I'm trying to figure out how to pull (in this example) the States (if they ex...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23585459.htm...
