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, 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
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
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
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
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
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
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
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
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
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
How do I use SQL 2005 after installation?
Answer Question | January 30, 2013 1:38 PM
SQL Server 2005, SQL Server installation
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
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
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
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
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
How can I get the AdventureWorks database for SQL Server 2005 SP1??
Answer Question | December 14, 2012 9:35 AM
AdventureWorks, SQL Server 2005
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
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