Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, CRM, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, Oracle, OS, Routers, RPG, RPGLE, SAP, Servers, SQL, SQL Server, SQL Server 2005, Storage, Virtualization, Visual Basic, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
I've been trying to calculate business days between two different dates in Oracle select. I've reached the point that my calculation is giving me the correct results (mostly) for the dates but sometimes it varies from 2 days to -2 days. Here's what I have: SELECT ((to_char(CompleteDate,'J') -...
My organization have AD domain on one machine including windows server 2003 and exchange 2003. The company has bought another company with difference entity, so I created a child domain with the exiting windows 2000 server machine from the new company. Is it possible to have users on a child domain...
I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any...
Hi, Can anyone please provide the checklist for labeling the cables in the data center. Please help me out.
I need to create a desktop shortcut for VBs for users using an application mapped from the network. I have 100 users just need to create a desktop shortcut to open an application run from my network drive and them apply to my gpos OU. thanks
What software will open a CDR file made by Corel?
I'm fairly new to Oracle (and triggers particularly) but I need to do an auto-increment in Oracle 11g Express and SQL Developer. This is what I have so far: CREATE TABLE theschema.thetable (id NUMBER PRIMARY KEY, name VARCHAR2(30)); CREATE SEQUENCE theschema.test1_sequence START WITH 1 INCREMENT BY...
I'm looking to insert several small rows quickly into Oracle. Using MySQL, I broke the inserts into groups of 100, then use one insert statement for every group of 100 inserts. But with Oracle, the mass inserts are way too slow. Is there a way I can speed it up?
Hi, I'm generating a csv file from an open hub in BW so I need to convert it into a xlsx one due to I need to upload it into the Microsoft SharePoint. Is there an abap function that does it? I know that there is one to convert an xls one into a csv. Thanks
Does anyone know how to get the user profile using SQL stored procedure?
I have 400 dollars to spend on a new laptop and I was wondering what I should get to get the best bang for my buck
After defragmenting my system disc, there sometimes remains a lot of fragmented .rbf files.I understand these files can be safely deleted.I also read that the Config.msi directory and files therein are automatically removed upon successful installation.This is not the case on my computer.How can I...
Hi, I am a IT professional looking into getting certified in SAP, I was wondering which certification and in waht are is the most in demand.
Hi , I am facing issue in RCVJRNE command. I m using RCVJRNE command to read journal. I used RCVJRNE command in CLLE program and i submitted the CLLE program in batch job. But whenever the journal receiver is full or attaching/detaching new jounral receiver, RCVJRNE command is ended.The command is...
How would I be able to "group by" a query using an alias. Something like this: select count(*), (select * from....) as alias_column from table group by alias_column The only thing is that I keep getting this 'alias_column' : INVALID_IDENTIFIER error message. What should I do here?
Can we use count on count or avg on avg? Meaning can we nest the aggregate functions...if yes...then how?
Hi guys, I want to create trigger to avoid users updating records or when he update that data want to write one log file with his Login ID, time, date etc. Please help me. If these is possible using trigger then please tell me how? Thanks Amar
Why does the screen on my computer keep flickering?
How do I remove "SearchIndexer.exe-Application Error?
I am running Windows XP Home on my laptop and want to install a linux OS (Fedora Core 7)on the 4GB of unpartitioned space on my hard drive. Would this cause any conflicts with my Windows OS?