SQL Stored Procedure
I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.
Answer Question
| December 19, 2008 2:50 PM
iSeries, ODBC, SQL, SQL stored procedures
I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.
Answer Question
| December 19, 2008 2:50 PM
iSeries, ODBC, SQL, SQL stored procedures
SQL statement exceeding 2000 characters in Oracle Graphics Builder
In Developer 6i Graphics Builder, i am not able to write query exceeding 2000 character. i think it is restriction in this version. If I want to write query exceeding 2000 then please suggest me what to do.
Answer Question
| December 10, 2008 10:27 AM
Oracle Developer 6i, Oracle Developer 6i Graphics Builder, Oracle Developer Suite, Oracle development, SQL, SQL statements
In Developer 6i Graphics Builder, i am not able to write query exceeding 2000 character. i think it is restriction in this version. If I want to write query exceeding 2000 then please suggest me what to do.
Answer Question
| December 10, 2008 10:27 AM
Oracle Developer 6i, Oracle Developer 6i Graphics Builder, Oracle Developer Suite, Oracle development, SQL, SQL statements
SQL Server 2000 script
Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item’s price with second max(effective_date). Thanks in advance.
Answer Question
| December 11, 2008 10:31 AM
Conditional SQL statements, SQL, SQL Query, SQL Server 2000, SQL Server 2000 Scripts, SQL Server Scripts
Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item’s price with second max(effective_date). Thanks in advance.
Answer Question
| December 11, 2008 10:31 AM
Conditional SQL statements, SQL, SQL Query, SQL Server 2000, SQL Server 2000 Scripts, SQL Server Scripts
SQL error. There is already an object named ‘InitCap2′ in the database.
I am running the following code in Microsoft SQL Server Management Studio Express, and after I run it, I get the following error, even though it is returning the record set that I am looking for. I would like to get rid of this error. Thanks. The error is: Msg 2714, Level 16, State 5, [...]
Answer Question
| December 5, 2008 8:21 PM
InitCap2, SQL, SQL Server errors, SQL Server Management Studio, SQL Server Management Studio Express
I am running the following code in Microsoft SQL Server Management Studio Express, and after I run it, I get the following error, even though it is returning the record set that I am looking for. I would like to get rid of this error. Thanks. The error is: Msg 2714, Level 16, State 5, [...]
Answer Question
| December 5, 2008 8:21 PM
InitCap2, SQL, SQL Server errors, SQL Server Management Studio, SQL Server Management Studio Express
SQL Find a number between the given ranges of number / Find a row which has range of given number
I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: [...]
Answer Question
| December 5, 2008 2:53 PM
MSSQL, SQL, SQL tables
I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: [...]
Answer Question
| December 5, 2008 2:53 PM
MSSQL, SQL, SQL tables
Conditional processing in embedded SQL
I’d like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = ‘AgtMaster’ C+ Then C+ Fetch Next From [...]
Answer Question
| December 4, 2008 6:25 PM
Conditional expressions, Embedded SQL, SELECT statement, SQL
I’d like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = ‘AgtMaster’ C+ Then C+ Fetch Next From [...]
Answer Question
| December 4, 2008 6:25 PM
Conditional expressions, Embedded SQL, SELECT statement, SQL
SQL Error
SQSQL Error :Component SARWFNUM:SQLSTATE 37000L Error :Component SARWFNUM:SQLSTATE 37000SQL Error :Component SARWFNUM:SQLSTATE 37000
Answer Question
| December 4, 2008 9:00 AM
SQL, SQL Error :Component SARWFNUM:SQLSTATE 37000, SQL error messages
SQSQL Error :Component SARWFNUM:SQLSTATE 37000L Error :Component SARWFNUM:SQLSTATE 37000SQL Error :Component SARWFNUM:SQLSTATE 37000
Answer Question
| December 4, 2008 9:00 AM
SQL, SQL Error :Component SARWFNUM:SQLSTATE 37000, SQL error messages
SQL Table Join when the name of a column in Table1 equals the value of a column in Table2
Does anyone know how to write the SQL to join two DB2 tables when the name of Table1.columnA equals the data values stored in Table2.columnB? In the table structure examples listed below, I’m trying to figure out how to join Table1 and Table2 when the values in Table2.Tag_Name are equal to the column names in [...]
Answer Question
| November 3, 2009 8:13 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL
Does anyone know how to write the SQL to join two DB2 tables when the name of Table1.columnA equals the data values stored in Table2.columnB? In the table structure examples listed below, I’m trying to figure out how to join Table1 and Table2 when the values in Table2.Tag_Name are equal to the column names in [...]
Answer Question
| November 3, 2009 8:13 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL
How can I join 3 tables using JOIN keyword
Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT … WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!
Answer Question
| December 8, 2008 6:20 AM
JOIN statement, PL/SQL, SELECT statement, SQL, SQL Query, WHERE statement
Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT … WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!
Answer Question
| December 8, 2008 6:20 AM
JOIN statement, PL/SQL, SELECT statement, SQL, SQL Query, WHERE statement
run oracle 9i with Windows Server 2003 Domain Controller
sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like SQL. what [...]
Answer Question
| December 4, 2008 5:58 AM
Domain Controller, Oracle 9i, Oracle 9i installation, Oracle installation, Oracle SQL, SQL, Windows Server 2003, Windows Server 2003 Domain Controller, Windows XP
sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like SQL. what [...]
Answer Question
| December 4, 2008 5:58 AM
Domain Controller, Oracle 9i, Oracle 9i installation, Oracle installation, Oracle SQL, SQL, Windows Server 2003, Windows Server 2003 Domain Controller, Windows XP
Round GPA to tenths and remove decimal in SQL
I have a field in a table, ACT_OVGPA that represents a student’s current overall gpa. The field is a 2 digit number on a scale of 00-40 where I believe there is an implied decimal point and actually represents 0.0 – 4.0. This is what I have written, but it returns an error “too many [...]
Answer Question
| December 3, 2008 2:53 PM
SQL, SQL error messages
I have a field in a table, ACT_OVGPA that represents a student’s current overall gpa. The field is a 2 digit number on a scale of 00-40 where I believe there is an implied decimal point and actually represents 0.0 – 4.0. This is what I have written, but it returns an error “too many [...]
Answer Question
| December 3, 2008 2:53 PM
SQL, SQL error messages
SQL Server 2005 or 2008?
I am a database user going back many years and have used several different platforms from the high-end (NCR’s Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical modelling and analysis. We also [...]
Answer Question
| December 8, 2008 6:05 PM
Microsoft Access, SAS, SQL, SQL Server 2005, SQL Server 2005 vs SQL Server 2008, SQL Server 2008, SQL Server Version Comparison
I am a database user going back many years and have used several different platforms from the high-end (NCR’s Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical modelling and analysis. We also [...]
Answer Question
| December 8, 2008 6:05 PM
Microsoft Access, SAS, SQL, SQL Server 2005, SQL Server 2005 vs SQL Server 2008, SQL Server 2008, SQL Server Version Comparison
Does similar ClearPool() from .NET Framework 2.x exist in .NET Framework 1.x
I’m looking for a method similar to the ClearPool() from .Net Framework 2.x but this method must work in .Net Framework 1!
Answer Question
| December 2, 2008 8:56 AM
.NET development, .NET Framework, .NET Framework 1.0, .NET Framework 2.0, .NET Framework 3.0, ClearPool, SQL, SqlConnection.ClearPool Method
I’m looking for a method similar to the ClearPool() from .Net Framework 2.x but this method must work in .Net Framework 1!
Answer Question
| December 2, 2008 8:56 AM
.NET development, .NET Framework, .NET Framework 1.0, .NET Framework 2.0, .NET Framework 3.0, ClearPool, SQL, SqlConnection.ClearPool Method
SQL Writer
SQL Writer library failed initialization. Your installattion iseither corrupt or has been tampered with. Please uninstall then re-run setupto correct this problem. How should I handle this?
Answer Question
| December 1, 2008 1:39 PM
SQL, SQL writer, SQL Writer error messages
SQL Writer library failed initialization. Your installattion iseither corrupt or has been tampered with. Please uninstall then re-run setupto correct this problem. How should I handle this?
Answer Question
| December 1, 2008 1:39 PM
SQL, SQL writer, SQL Writer error messages
Need SQL query
I have two tables DETAIL and USER. Detail table have two columns (projectid and projectdetail). Projectid is a primary key in DETAIL table. USER table have two columns (projectid and Userid). User table is like more than one userid can be under each projectid, one user can access more than one projectid. like the following [...]
Answer Question
| January 15, 2009 10:29 AM
SELECT statement, SQL, SQL Query
I have two tables DETAIL and USER. Detail table have two columns (projectid and projectdetail). Projectid is a primary key in DETAIL table. USER table have two columns (projectid and Userid). User table is like more than one userid can be under each projectid, one user can access more than one projectid. like the following [...]
Answer Question
| January 15, 2009 10:29 AM
SELECT statement, SQL, SQL Query
SQL Query
i want to write a SQL query to get two random question one from first set of questions and second from second set of questions.
Answer Question
| December 1, 2008 4:57 AM
SQL, SQL Query
i want to write a SQL query to get two random question one from first set of questions and second from second set of questions.
Answer Question
| December 1, 2008 4:57 AM
SQL, SQL Query
I want to retrieve always the first record via sql
I want to retrieve always the first record of a group of records i.e. a history of sold articles, I want to see the date of every first sold article
Answer Question
| November 26, 2008 3:23 PM
SQL, SQL Database, SQL Record
I want to retrieve always the first record of a group of records i.e. a history of sold articles, I want to see the date of every first sold article
Answer Question
| November 26, 2008 3:23 PM
SQL, SQL Database, SQL Record
Converting SQL data to Microsoft Access through coding in VB.NET
I have tables in SQL and i want to port them to MS access through coding in VB.NET
Answer Question
| November 26, 2008 7:01 AM
Data migration, Database, Microsoft Access, SQL, Visual Basic .NET
I have tables in SQL and i want to port them to MS access through coding in VB.NET
Answer Question
| November 26, 2008 7:01 AM
Data migration, Database, Microsoft Access, SQL, Visual Basic .NET
Two programs with separate SQL Databases
I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?
Answer Question
| November 21, 2008 11:07 PM
Database, SQL, SQL Database
I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?
Answer Question
| November 21, 2008 11:07 PM
Database, SQL, SQL Database
SQL to pull consecutive numbers rows
Hello, I have a table with these sample recs. ColA ColB ColC 00100 295.00 295.00 00100 295.01 295.01 00100 295.02 295.02 00100 295.03 295.03 00100 295.04 295.04 00100 295.05 295.05 00100 295.10 295.15 00100 295.98 295.98 What SQL query (prefers not to use cursor if possible since it will involves 2 millions rows and can [...]
Answer Question
| November 20, 2008 10:49 PM
SQL, SQL Query
Hello, I have a table with these sample recs. ColA ColB ColC 00100 295.00 295.00 00100 295.01 295.01 00100 295.02 295.02 00100 295.03 295.03 00100 295.04 295.04 00100 295.05 295.05 00100 295.10 295.15 00100 295.98 295.98 What SQL query (prefers not to use cursor if possible since it will involves 2 millions rows and can [...]
Answer Question
| November 20, 2008 10:49 PM
SQL, SQL Query
