how can we use sql subquery in jsp?i am trying to write it but it gives me an error of missing operand?
Answer Question | April 29, 2008 1:53 PM
JSP, SQL, Subquery, Web development
I need to help out in a move of a site coded in ASP/VBScript from one host we’re having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don’t know how to move the SQL database along with [...]
Answer Question | May 8, 2008 2:54 AM
ASP, Database migration, SQL, SQL Database, VBScript, Web development
Hi i have a scenario of n level tree structure.in order to traverse to my desired node i am using Recursive function until i get my desired node in my vb code but i am getting a performance issue. SO i reckon that this performance can be overcome by using sql udf or stored procedure. [...]
Answer Question | April 28, 2008 7:38 AM
Recurive function, Recursion, SQL, SQL UDF, VB, Visual Basic
A reader wrote in with this SQL stored procedure question. Our AS/400 experts weren’t as familiar with this topic. So, any SQL experts out there with an answer? Do I have to hard code the library in my stored procedure? I have my procedures in sqltblsrc and have to edit the library to create the [...]
Answer Question | April 25, 2008 3:38 PM
SQL, SQL stored procedures
A reader wrote in with this question, but it’s not one that our AS/400 experts could answer. So any Microsoft SQL experts out there, please chime in: I am an SQL novice…….I am getting the following error message: [Microsoft][ODBC SQL Server Driver][SQLServer] The conversion of a char data type to a datetime data type resulted [...]
Answer Question | April 25, 2008 3:34 PM
After (successfully???) attaching a database to a VM Ware instance of MS SQL Server 2005 and setting what appear to be appropriate access to the SQL server itself and the database involved, and making sure that sharing and security are properly set on the SQL server, I am receiving the following error when attempting to [...]
Answer Question | April 25, 2008 9:21 PM
Database, Servers, SQL, SQL Server 2005
I need a report that provides an aggregate of a string column – in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish this and my [...]
Answer Question | July 15, 2011 7:39 PM
AS/400, AS/400 DB2, DB2/400, SQL
We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. Because the cluster is [...]
Answer Question | April 24, 2008 6:23 PM
SQL, SQL Server 2005, SQL Server clustering
In t-sql, I want to store the date from the getDate() function in GMT time instead of local time.
Answer Question | April 21, 2008 6:42 PM
convert, getDate(), GMT, SQL, T/SQL
Which command I can use to get the relation between all tables in a system application?
Answer Question | April 21, 2008 8:23 PM
AS/400 DB2, SQL
Is there any way I can create a stored procedure which will check for the Transaction Log file size – where we have a specified limit to grow – and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?
Answer Question | April 18, 2008 1:11 PM
SQL Server availability, SQL Server stored procedures, SQL Server transaction logs
I need to be able to count how many values are greater than 1 for each StuNum. I have only been able to count how many values are greater than 1 for each StuNum for d1 or for d2 or for d3, but not for d1, d2 and d3. How can I have it count [...]
Answer Question | April 18, 2008 10:58 PM
COUNT, GROUP BY statement, SQL
I need to query a large remote weather database for events reported within time frames without regard for the day. For instance, I need all data that was reported for the fifteen minute window closest to noon each day for the last twelve years. I don’t care about specific dates, just the daily time windows. [...]
Answer Question | April 18, 2008 7:29 PM
SQL, SQL Query
I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql? Query used to import where sheet name = data SELECT * INTO tmp_test2 FROM OPENROWSET(‘Microsoft.Jet.OLEDB.4.0′, ‘Excel 8.0;Database=c:datatest2.xls’, ‘SELECT * FROM [data$]‘) Thanks
Answer Question | April 19, 2008 3:52 PM
Microsoft Excel, SQL
Two tables, First Table –FN—LN—-Reasons John | Doe | 6 | Jane | Doe | 2 | —————– That’s the end of the first table. Second Table —Reason—-Reason Detail—– 2 | Invalid SSN 4 | Invalid Date Of Birth ————————————– That’s the end of the second table. (*Note, there is NO value of ’6′ in [...]
Answer Question | April 20, 2012 11:37 PM
Database, Developers, Development, Query, Query tuning, SQL, SQL Query
Our database was designed with separate fields for cc, yy, mm and dd. I’d like to know if and how these fields can be combined into one field then order by on that field. Is this possible? I would need to know the syntax also. If this is not possible, then is there a another [...]
Answer Question | April 17, 2008 1:14 PM
Concatenate, Database, RPG, SQL
Our db group wants to remove ODBC access. My application relies on ODBC to get data. What are the alternatives?
Answer Question | April 17, 2008 7:52 PM
Database connectivity, ODBC, SQL
If I am a beginner at SQL and want to learn more , what class would you reccomend I start with?
Answer Question | June 20, 2008 7:17 PM
i did degree in electronics and communication after that i did job in sofware company for 8 months as assistant system engineer with cobol, sql technology. i have basic knowledge of c, cobol, sql and html. what kind of job should i search, i need one more suggestion that in which field i should go [...]
Answer Question | April 18, 2008 2:21 PM
Career development, Certifications, COBOL, HTML, IT careers, SQL
What are the pros/cons of truncate a table export/import to just drop table?
Answer Question | April 14, 2008 3:37 PM