Best practice when using a shared table across multiple databases
Hi everyone! I thought I would easily find a discussion on the internet about this subject but I didn’t find anything to really help me. I have many applications that need to share common tables. Think about an Employee table for example. I don’t want to have this table duplicated in each project’s database! With [...]
Answer Question
| March 7, 2013 1:24 AM
SQL Server, SQL Server 2012
Hi everyone! I thought I would easily find a discussion on the internet about this subject but I didn’t find anything to really help me. I have many applications that need to share common tables. Think about an Employee table for example. I don’t want to have this table duplicated in each project’s database! With [...]
Answer Question
| March 7, 2013 1:24 AM
SQL Server, SQL Server 2012
Which config file does MySQL use?
Hi, I’m having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message: Default options [...]
Answer Question
| March 5, 2013 2:55 PM
MySQL, MySQL 5.0, Zend, Zend Server
Hi, I’m having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message: Default options [...]
Answer Question
| March 5, 2013 2:55 PM
MySQL, MySQL 5.0, Zend, Zend Server
Getting 2008 voting data inside Spatial
When creating a choropleth map, first I must obtain the data. If I have the table of values in my possession, what are the steps for moving the data inside Spatial?
Answer Question
| March 4, 2013 3:16 PM
SQL Server 2008, SQL Server Spatial Data
When creating a choropleth map, first I must obtain the data. If I have the table of values in my possession, what are the steps for moving the data inside Spatial?
Answer Question
| March 4, 2013 3:16 PM
SQL Server 2008, SQL Server Spatial Data
SQL Studio 2005 expired but it is not evaluation copy?
What happened? SQL Studio 2005 says evaluation period has expired even though I have a licensed copy of SQL Server 2005 installed. Please help.
Answer Question
| March 4, 2013 2:24 PM
SQL Server 2005, SQL Studio
What happened? SQL Studio 2005 says evaluation period has expired even though I have a licensed copy of SQL Server 2005 installed. Please help.
Answer Question
| March 4, 2013 2:24 PM
SQL Server 2005, SQL Studio
Constant variable in SQL cursor
select gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999) This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and ’G’ are constants [...]
Answer Question
| February 28, 2013 7:23 PM
AS/400, SQL Cursors
select gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999) This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and ’G’ are constants [...]
Answer Question
| February 28, 2013 7:23 PM
AS/400, SQL Cursors
SAN to SAN hardware level replicaiton to replicate MSSQL 2008 R2 databases
If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases’ MDF and LDF files.
Answer Question
| February 28, 2013 9:26 AM
MSSQL, MSSQL 2008, SAN
If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases’ MDF and LDF files.
Answer Question
| February 28, 2013 9:26 AM
MSSQL, MSSQL 2008, SAN
Assign a serial number for each group
I want to assign a serial number for the below data using the Access query or by using SQL for Access DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211 I want the output like as below: S.noDateItems Sold12/1/201354622/1/201389715/1/201325625/1/2013103235/1/201378518/2/201365428/2/20131211 Can anyone help me?
Answer Question
| February 25, 2013 9:59 AM
Microsoft Access 2002, SQL 2000
I want to assign a serial number for the below data using the Access query or by using SQL for Access DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211 I want the output like as below: S.noDateItems Sold12/1/201354622/1/201389715/1/201325625/1/2013103235/1/201378518/2/201365428/2/20131211 Can anyone help me?
Answer Question
| February 25, 2013 9:59 AM
Microsoft Access 2002, SQL 2000
Data migration from AS/400 DB2 to SQL Server
Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?
Answer Question
| February 22, 2013 6:56 AM
AS/400, SQL Server
Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?
Answer Question
| February 22, 2013 6:56 AM
AS/400, SQL Server
Recursive SQL error
For the life of me I can not see what my problem is. Any help would be appreciated. *************** Beginning of data **************************************** WITH RPL (LEVEL, PINBR, CINBR, QTYPR) AS (SELECT 1, ROOT.PINBR, ROOT.CINBR, ROOT.QTYPR FROM ITSTRU ROOT WHERE ROOT.PINBR = ’8B714-0005651′ UNION ALL SELECT PARENT.LEVEL+1, CHILD.PINBR, CHILD.CINBR, CHILD.QTYPR FROM RPL PARENT, ITSTRU CHILD WHERE [...]
Answer Question
| February 12, 2013 8:27 PM
SQL error messages, SQL statements
For the life of me I can not see what my problem is. Any help would be appreciated. *************** Beginning of data **************************************** WITH RPL (LEVEL, PINBR, CINBR, QTYPR) AS (SELECT 1, ROOT.PINBR, ROOT.CINBR, ROOT.QTYPR FROM ITSTRU ROOT WHERE ROOT.PINBR = ’8B714-0005651′ UNION ALL SELECT PARENT.LEVEL+1, CHILD.PINBR, CHILD.CINBR, CHILD.QTYPR FROM RPL PARENT, ITSTRU CHILD WHERE [...]
Answer Question
| February 12, 2013 8:27 PM
SQL error messages, SQL statements
Stored procedures
What is meant by stored procedures? What is purpose of them and where can we use this stored procedure? Can any one provide the information regarding this? Thanks in advance.
Answer Question
| February 12, 2013 6:33 AM
SQL statement, Stored Procedures
What is meant by stored procedures? What is purpose of them and where can we use this stored procedure? Can any one provide the information regarding this? Thanks in advance.
Answer Question
| February 12, 2013 6:33 AM
SQL statement, Stored Procedures
Trap SQLCODE from RUNSQLSTM
I have a RUNSQLSTM that updates a table. When it hits a duplicate, it quits and returns SQL9010. What I want it to do is just skip the step that got a duplicate and move on. Is there a way to do this?
Answer Question
| February 7, 2013 9:13 PM
RUNSQLSTM, SQLCODES
I have a RUNSQLSTM that updates a table. When it hits a duplicate, it quits and returns SQL9010. What I want it to do is just skip the step that got a duplicate and move on. Is there a way to do this?
Answer Question
| February 7, 2013 9:13 PM
RUNSQLSTM, SQLCODES
How to open SQL 2005 after installation
How do I use SQL 2005 after installation?
Answer Question
| January 30, 2013 1:38 PM
SQL Server 2005, SQL Server installation
How do I use SQL 2005 after installation?
Answer Question
| January 30, 2013 1:38 PM
SQL Server 2005, SQL Server installation
Validate SQL and display the output
I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether [...]
Answer Question
| January 29, 2013 8:14 AM
SQL Query, SQL scripts, SQLRPGLE
I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether [...]
Answer Question
| January 29, 2013 8:14 AM
SQL Query, SQL scripts, SQLRPGLE
Run Oracle Procedure in SSRS dataset
Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.
Answer Question
| January 28, 2013 7:43 PM
Oracle, SSRS, Stored Procedure
Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.
Answer Question
| January 28, 2013 7:43 PM
Oracle, SSRS, Stored Procedure
High usage of SQL Server
The SQL Server usage becomes high….How do I reduce the usage of SQL Server? The system performance becomes slow.
Answer Question
| January 21, 2013 11:55 AM
Data usage, SQL Server
The SQL Server usage becomes high….How do I reduce the usage of SQL Server? The system performance becomes slow.
Answer Question
| January 21, 2013 11:55 AM
Data usage, SQL Server
Network & server issues
We are a retail company dealing with textile , retail business. We have about 4 branches within the span of around 250 to 300 kms from our main office. In a branch we have about 60-70 computers with thin clients operating with the help of IBM BLADE server. Total, we have about 250-270 computers accessing [...]
Answer Question
| January 21, 2013 5:37 AM
IBM BladeServer, SQL Server
We are a retail company dealing with textile , retail business. We have about 4 branches within the span of around 250 to 300 kms from our main office. In a branch we have about 60-70 computers with thin clients operating with the help of IBM BLADE server. Total, we have about 250-270 computers accessing [...]
Answer Question
| January 21, 2013 5:37 AM
IBM BladeServer, SQL Server
Entry Level Vendor Neutral SQL Certification
Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks for your help.
Answer Question
| December 18, 2012 2:54 PM
SQL, SQL certifications
Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks for your help.
Answer Question
| December 18, 2012 2:54 PM
SQL, SQL certifications
Attaching AdventureWorks database To SQL Server 2005 SP1
How can I get the AdventureWorks database for SQL Server 2005 SP1??
Answer Question
| December 14, 2012 9:35 AM
AdventureWorks, SQL Server 2005
How can I get the AdventureWorks database for SQL Server 2005 SP1??
Answer Question
| December 14, 2012 9:35 AM
AdventureWorks, SQL Server 2005
encryting output file from BCP
I am exporting data using BCP util, in SQL native format, creating an output format. The proces executes a stored procedure, creating a temporary table, and then the BCP exports the table to an output file, in native SQL. Is there a method to have this output file encrypted without a 3rd party process?
Answer Question
| December 7, 2012 4:17 PM
BCP Utility, encrypt files
I am exporting data using BCP util, in SQL native format, creating an output format. The proces executes a stored procedure, creating a temporary table, and then the BCP exports the table to an output file, in native SQL. Is there a method to have this output file encrypted without a 3rd party process?
Answer Question
| December 7, 2012 4:17 PM
BCP Utility, encrypt files
Joining unmatched tables with duplicates
Hi, I am a beginner SQL user and am trying to take table 1 (contracts) and pull in the calltype from table2 (equipment) with the control number as the common field. However, there are duplicate control numbers in table2 which are causing me an issue. I have created this query on table 2 to get [...]
Answer Question
| November 29, 2012 5:50 PM
Microsoft SQL Server 2005, SQL Server tables
Hi, I am a beginner SQL user and am trying to take table 1 (contracts) and pull in the calltype from table2 (equipment) with the control number as the common field. However, there are duplicate control numbers in table2 which are causing me an issue. I have created this query on table 2 to get [...]
Answer Question
| November 29, 2012 5:50 PM
Microsoft SQL Server 2005, SQL Server tables
