Limit number of rows in a table
Dear all, I’d just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 [...]
Answer Question
| February 6, 2009 7:26 AM
Auto increment, Database programming, SQL
Dear all, I’d just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 [...]
Answer Question
| February 6, 2009 7:26 AM
Auto increment, Database programming, SQL
To retrieve records from SQL Server database
Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named “Name” in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on…. Now, through some application [...]
Answer Question
| February 10, 2009 3:35 AM
Query optimization, SQL, SQL Server development, SQL Server Query
Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named “Name” in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on…. Now, through some application [...]
Answer Question
| February 10, 2009 3:35 AM
Query optimization, SQL, SQL Server development, SQL Server Query
Stored Procedures, One Database, Different Software Releases
Hi Everyone. Currently at my work we use SQL in our VB.NET code. I have previously always used stored procedures for all of their benefits. My company has said that our customers might use different versions of our software against its one database. For example: While a customer is migrating from release 1 to release [...]
Answer Question
| February 24, 2009 9:20 AM
Release management, Software maintenance, SQL, Stored Procedures, VB.NET, Visual Basic .NET
Hi Everyone. Currently at my work we use SQL in our VB.NET code. I have previously always used stored procedures for all of their benefits. My company has said that our customers might use different versions of our software against its one database. For example: While a customer is migrating from release 1 to release [...]
Answer Question
| February 24, 2009 9:20 AM
Release management, Software maintenance, SQL, Stored Procedures, VB.NET, Visual Basic .NET
SQL View- Adding a table from a different server.
Can I add a table from another MSSQL Server on the network to an SQL view and how?
Answer Question
| February 3, 2009 7:38 PM
AS/400 SQL View, SQL
Can I add a table from another MSSQL Server on the network to an SQL view and how?
Answer Question
| February 3, 2009 7:38 PM
AS/400 SQL View, SQL
sqldumper
is sqldumper caused by low memory in computer if not what is it caused by and how do i get rid of it
Answer Question
| February 4, 2009 7:11 PM
SQL, sql dumper, SQL performance, SQL Server memory, SQL Server performance
is sqldumper caused by low memory in computer if not what is it caused by and how do i get rid of it
Answer Question
| February 4, 2009 7:11 PM
SQL, sql dumper, SQL performance, SQL Server memory, SQL Server performance
ORA-03113: end-of-file on communication channel
I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am running this script as part of [...]
Answer Question
| February 10, 2009 3:54 PM
ORA-03113, Oracle error messages, Oracle SQL, SQL, SQLPlus
I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am running this script as part of [...]
Answer Question
| February 10, 2009 3:54 PM
ORA-03113, Oracle error messages, Oracle SQL, SQL, SQLPlus
Converting date time in C#
hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in [...]
Answer Question
| February 3, 2009 8:07 AM
C, Data Types, DateTime, SQL, VARCHAR, XML
hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in [...]
Answer Question
| February 3, 2009 8:07 AM
C, Data Types, DateTime, SQL, VARCHAR, XML
VERY slow server startup and shutdown
Hi everybody! We have a problem on our Exchange 2003 server thats been getting worse and worse. We have a Dell PowerEdge 2850 server, and every time we try to shutdown or restart it, it take 10 to 20 minutes just to shut down and another 20 to startup. Sometimes we have to force shut [...]
Answer Question
| March 29, 2012 1:00 AM
Dell PowerEdge 2850, Exchange 2003, Exchange 2003 performance, Hardware, Server Performance, SQL, SQL database corrupt
Hi everybody! We have a problem on our Exchange 2003 server thats been getting worse and worse. We have a Dell PowerEdge 2850 server, and every time we try to shutdown or restart it, it take 10 to 20 minutes just to shut down and another 20 to startup. Sometimes we have to force shut [...]
Answer Question
| March 29, 2012 1:00 AM
Dell PowerEdge 2850, Exchange 2003, Exchange 2003 performance, Hardware, Server Performance, SQL, SQL database corrupt
Need help with SQL commands
hye there i need some guidance on sql command. i accidently update all data in 1 table to be as one data only. may i know how i want to revert back to the previous data. or at least what is the sql command to use to make the data in that table updated according [...]
Answer Question
| February 2, 2009 5:29 AM
SQL, SQL commands
hye there i need some guidance on sql command. i accidently update all data in 1 table to be as one data only. may i know how i want to revert back to the previous data. or at least what is the sql command to use to make the data in that table updated according [...]
Answer Question
| February 2, 2009 5:29 AM
SQL, SQL commands
SQL Statement to update a table with set conditions on another table
Hi, Can anyone help me? I am trying to update a second table with criteria in its own and another table being set. This is what I have come up with and various others. It should give an idea of what I am trying to do. UPDATE Clientextradetails LEFT JOIN Clients ON Clients.ClientRef = ClientExtraDetails.ClientRef [...]
Answer Question
| January 29, 2009 3:21 PM
SQL, SQL statements
Hi, Can anyone help me? I am trying to update a second table with criteria in its own and another table being set. This is what I have come up with and various others. It should give an idea of what I am trying to do. UPDATE Clientextradetails LEFT JOIN Clients ON Clients.ClientRef = ClientExtraDetails.ClientRef [...]
Answer Question
| January 29, 2009 3:21 PM
SQL, SQL statements
Define array in Oracle
i have coulumb stn varchar2(100) , i want to split it to 4 columbs n1 varcha2(20)…n4 varchar2(20) ,depend on space eg: stn : John Adms Smith Zac n1 : John n2 : Adms n3 : Smith n4 : Zac i use oracle8.0.5 developer6
Answer Question
| January 29, 2009 7:42 AM
Arrays, Oracle 8i, Oracle development, SQL, VARCHAR
i have coulumb stn varchar2(100) , i want to split it to 4 columbs n1 varcha2(20)…n4 varchar2(20) ,depend on space eg: stn : John Adms Smith Zac n1 : John n2 : Adms n3 : Smith n4 : Zac i use oracle8.0.5 developer6
Answer Question
| January 29, 2009 7:42 AM
Arrays, Oracle 8i, Oracle development, SQL, VARCHAR
How to find a specific word in a SQL table
How do you write a SQL query to find a specific word in a SQL column. Example: I want to show all records that have the word Bob in it but do not want to include records that are Bobby or Bobble etc., only the exact word Bob. Hope that makes sense.
Answer Question
| April 18, 2013 3:13 AM
SELECT statement, SQL, SQL Query, WHERE statement
How do you write a SQL query to find a specific word in a SQL column. Example: I want to show all records that have the word Bob in it but do not want to include records that are Bobby or Bobble etc., only the exact word Bob. Hope that makes sense.
Answer Question
| April 18, 2013 3:13 AM
SELECT statement, SQL, SQL Query, WHERE statement
How to create a loop query in SQL.
Hello Friends, I am trying to write a SQL code to pull all the parts in a chain. For eg., Part A is replaced by Part B and Part B is replaced by Part C and C to D and so on. Is there anyway that I can pull all the parts in that loop [...]
Answer Question
| May 6, 2010 9:54 PM
Loop query in SQL, SQL, SQL Query
Hello Friends, I am trying to write a SQL code to pull all the parts in a chain. For eg., Part A is replaced by Part B and Part B is replaced by Part C and C to D and so on. Is there anyway that I can pull all the parts in that loop [...]
Answer Question
| May 6, 2010 9:54 PM
Loop query in SQL, SQL, SQL Query
SQL divisions
Hi All, I’m trying to make a calculation through SQL code but this is resulting in a 0. Example: declare @activities as integer declare @days as integer declare @media as float –my queries that extracts data and sets values to @days, @activities; in this case they return @activities=51 and @days=199 set @media = @activities/@days select [...]
Answer Question
| January 28, 2009 3:43 PM
SQL, SQL Calculations
Hi All, I’m trying to make a calculation through SQL code but this is resulting in a 0. Example: declare @activities as integer declare @days as integer declare @media as float –my queries that extracts data and sets values to @days, @activities; in this case they return @activities=51 and @days=199 set @media = @activities/@days select [...]
Answer Question
| January 28, 2009 3:43 PM
SQL, SQL Calculations
Pulling multiple values in the same line in SQL
Sorry if the title is a bit vague but its almost what am I trying to solve. The best way to explain my issue is this. If I have a table which takes the format.. user_id, error_code. (and other values also). The problem is that the same user_id is listed multiple times for each error_code [...]
Answer Question
| February 6, 2009 1:22 AM
SELECT statement, SQL, SQL Query
Sorry if the title is a bit vague but its almost what am I trying to solve. The best way to explain my issue is this. If I have a table which takes the format.. user_id, error_code. (and other values also). The problem is that the same user_id is listed multiple times for each error_code [...]
Answer Question
| February 6, 2009 1:22 AM
SELECT statement, SQL, SQL Query
can you help on this query?
I am new to sql and cannot work out the query for this: >>>List the films in which ‘Harrison Ford’ has appeared <<< movie(id, title, yr, score, votes, director) actor(id, name) casting(movieid, actorid, ord) The whole exercises can be found on http://sqlzoo.net/3.htm thanks in advance A.
Answer Question
| January 20, 2009 11:49 PM
JOIN statement, SQL, SQL Query
I am new to sql and cannot work out the query for this: >>>List the films in which ‘Harrison Ford’ has appeared <<< movie(id, title, yr, score, votes, director) actor(id, name) casting(movieid, actorid, ord) The whole exercises can be found on http://sqlzoo.net/3.htm thanks in advance A.
Answer Question
| January 20, 2009 11:49 PM
JOIN statement, SQL, SQL Query
Unable to use delete statement in SQLRPG
Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.
Answer Question
| January 22, 2009 11:43 AM
DELETE statement, Embedded SQL, RPG, SQL, SQLRPG
Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.
Answer Question
| January 22, 2009 11:43 AM
DELETE statement, Embedded SQL, RPG, SQL, SQLRPG
MS SQL query to update a table with the last entry in another table.
Hi, Could anyone please assist. I’m trying to update a Reporting Table with the last entry in another table. I’ve tried to arrange the table according to the ID row. This works great. Then the query to get the last entry woks as well, but to get the two to work together and update the [...]
Answer Question
| March 26, 2012 11:14 AM
Query, SQL, SQL queries, SQL Query, sql report, UPDATE statement
Hi, Could anyone please assist. I’m trying to update a Reporting Table with the last entry in another table. I’ve tried to arrange the table according to the ID row. This works great. Then the query to get the last entry woks as well, but to get the two to work together and update the [...]
Answer Question
| March 26, 2012 11:14 AM
Query, SQL, SQL queries, SQL Query, sql report, UPDATE statement
Merge two companies into one network
The company I work for has decided to merge with its Sister Company on the lower floor. While we share the same room to house our independent servers, both companies have separate physical networks. Each with their own separate File Servers & SQL servers. Allowing Company “A” employees to log into Server “A” (only) and [...]
Answer Question
| February 2, 2012 10:46 PM
Active Directory, DNS management, Domain configuration, Netwo, Network design, Server management, SQL, SQL Server 2000, SQL Server 2005, Windows 2000 Server, Windows Server 2003
The company I work for has decided to merge with its Sister Company on the lower floor. While we share the same room to house our independent servers, both companies have separate physical networks. Each with their own separate File Servers & SQL servers. Allowing Company “A” employees to log into Server “A” (only) and [...]
Answer Question
| February 2, 2012 10:46 PM
Active Directory, DNS management, Domain configuration, Netwo, Network design, Server management, SQL, SQL Server 2000, SQL Server 2005, Windows 2000 Server, Windows Server 2003
SQL Writer error
sql error in the start; either mesup or tempered
Answer Question
| January 20, 2009 12:58 AM
SQL, SQL writer, SQL Writer error messages
sql error in the start; either mesup or tempered
Answer Question
| January 20, 2009 12:58 AM
SQL, SQL writer, SQL Writer error messages
