Sql subquery
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
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
Moving a SQL database from one host to another
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
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
IS It Possible to create Recusrive function using sql udf or stored procedures?
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
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
Coding for library in stored procedures
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 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
SQL Error: Conversion of char data type to a datetime data type resulted in an out of range datetime value
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
DateTime, SQL
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
DateTime, SQL
SQL 2005 error code = 80004003: Invalid Pointer
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
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
String Aggregate Function
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
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
SQL 2005 Active/Active/Passive
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
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
Convert time to GMT time
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
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
SQL COMMAND to see table relation
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
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
Looking for a stored procedure to monitor size of Transaction Log file
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
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
Count several columns Group by accounts Greater than value Beginner
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 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
SQL Query for time data only
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 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
Is it possible to find out the name of an excel worksheet
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
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
Difficult SQL query, is this possible?
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
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
rpg sql concat
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 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
Alternatives to ODBC
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
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
Learning 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
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
SQL
in what direction should i work
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
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
Truncate or not Truncate SQL
What are the pros/cons of truncate a table export/import to just drop table?
Answer Question
| April 14, 2008 3:37 PM
PL/SQL, SQL
What are the pros/cons of truncate a table export/import to just drop table?
Answer Question
| April 14, 2008 3:37 PM
PL/SQL, SQL
