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

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

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

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

Navigation Pane
In Access 2003, my database window showed me all my database objects. Now I have a navigation pane that I have to scroll through to locate things. Is there any way to display all the objects in my database at once?

Answer Question   |  December 5, 2008  8:02 PM
Access 2003, Access 2003 Navigation Pane, Access Database, Access Navigation Pane, Microsoft Access

how can make this SQL Server query faster
All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as ’00′, ISNULL (td1.price, 0) as ’100′, ISNULL (td2.price, 0) as ’200′, ISNULL (td3.price, 0) as ’300′, ISNULL (td4.price, 0) as [...]

Answer Question   |  December 4, 2008  6:10 PM
SQL Query, SQL Server 2008, SQL stored procedures, T-SQL

SAP BI
In an effort to validate my opionion of SAP BW/Netweaver Capability – In terms of flexibility, KPI Development, and Predictive Analytics, If you had to decide, would you select SAP’s product or another OLAP tool and why? Situation: Global Manaufacturing Company, multiple lines of business, 2 instances of SAP US & Europe, Growing data requirements, [...]

Answer Question   |  August 26, 2009  4:19 PM
KPI, NetWeaver, OLAP/OLTP, SAP BI, SAP BW

New member contest: ASK, Answer and Win a $50 Amazon gift card
As 2008 winds to a close, IT Knowledge Exchange has one more fun contest to end the year. From today until December 23rd, you can enter to win one of ten $50 (US) Amazon.com gift cards. There are two things, however, that you must do in order to enter: 1. Ask 2 questions 2. Answer [...]

Answer Question   |  June 22, 2012  3:45 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP

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

How to test whether the Database tables designed to avoid deadlock occurence?
I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do? [...]

Answer Question   |  December 10, 2008  11:04 AM
Database deadlock, Database design, Database Failover, Database modeling, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server

I am getting “compiler error in hidden module” error in Excel 2003 while running Macro
I am getting :”compiler error in hidden module ” error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !

Answer Question   |  December 4, 2008  7:24 AM
Compile error in hidden module, Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel error messages

Crystal Reports 8
To Change The position & property of the Text in the crystal report from VB.NET code itself…. is It Possible??? while the Crystal report connected….. By Raam87

Answer Question   |  December 3, 2008  6:04 AM
Crystal Reports, Crystal Reports 8, VB, VB.NET, Visual Basic, Visual Basic .NET

Event ID:10010
Not able to ping the machine with the hostname/Netbios name.

Answer Question   |  December 5, 2008  3:58 AM
Event ID 10010, Network connectivity, Ping, Remote access, Remote connectivity, RPC

How organizations deal with network design for disaster recovery
I am looking for some information about how organizations deal with network design for disaster recovery. Specifically, my issue is about DNS domains, and whether to have a single network with a redundant warm site in a single domain shared by production processing, requiring unique IP addresses and server names in the secondary site, and [...]

Answer Question   |  December 2, 2008  10:53 PM
Disaster Recovery, DNS, Network design, Networking, Organizations, Testing

How do you tell Workflow to send an email to the initiator’s manager?
I’m trying to create a workflow that will send an email to an employee’s manager when that employee creates an expense report through the Portal. I’ve got the workflow set up and it currently sends to me when an expense report is created. So that part isn’t really an issue. The issue is how do [...]

Answer Question   |  December 2, 2008  9:44 PM
Email, SAP portal, SAP Workflow, Workflow

Missing Font In Adobe Creative Suite 3 Design
I recently installed Adobe’s Creative Suite 3 – Design on a new workstation. Our Graphic Artist immediately encountered a missing fonts issue. Some of the fonts this suite could not find are: Arial Narrow, Arial Narrow Bold, Arial Narrow Bold Italic, etc. I verified that these fonts are recognized by Windows XP Pro SP3. I [...]

Answer Question   |  December 2, 2008  8:31 PM
Adobe Creative Suite, Adobe Creative Suite 3, Adobe Creative Suite 3 Font

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

User security based on table in database
I am using Access 2003. I have a small (2 table) database. One table contains unit rework information. The second table contains User information(ID, FirstName, LastName, Security level). I built a form with a place for 3 users to ‘sign off’ – one for operators, one for supervisors & one for QA. Each of these [...]

Answer Question   |  December 4, 2008  4:14 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access

SQL Query
Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ———- ———- ——– 1 3 01-12-08 1 2 01-12-08 2 3 01-12-08 2 2 01-12-08 3 6 05-12-08 4 10 05-12-08 [...]

Answer Question   |  December 2, 2008  4:11 PM
Oracle Database, Oracle developers, SQL Query

How to test Application Robustness?
What are the factors that need to be considered to test the Robustness of the system? How do we ensure our application is Robust?

Answer Question   |  December 2, 2008  9:37 AM
Software performance testing, Software quality management, Software test design, Software testing, Software testing methodologies, Software testing tools