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
Does anyone know of a way, in MySQL, to replicate a SQL Server function "ROW_NUMBER()?" Here's my example: SELECT col1, col2, ROW_NUMBER() OVER (PARTITION BY col1, col2 ORDER BY col3 DESC) AS intRow FROM Table1 With this, I would be able to add a condition to limit "intRow" to 1 to get a single...
I currently have a MySQL table that looks like this: company_name action pagecount ------------------------------- Company A PRINT 3 Company A PRINT 2 Company A PRINT 3 Company B EMAIL Company B PRINT 2 Company B PRINT 2 Company B PRINT 1 Company A PRINT 3 But now I need to run a SQL query to get...
"Ethernet doesn't have a valid IP configuration." This delays the connecting to the Internet. How can this be fixed?
I want to be able to use my computer as my phone. I want to use a bluetooth headset. I want to open a program, dial a number on the screen, and make a call. I also want to be able to use the automatic dialer in Outlook 2010. How do I do make this possible?
I have a windows 12 domain server running on an independent 500gb HD. I also have 3 additional HD that files were saved on. I moved the files and want to remove the 3, now blank, HD's. When I remove them, the system will not boot. If the OS is on an independent drive, why won't the system boot with...
How do I change the print settings for SAP as when I try to print reports the text is huge and only the top left corner of the report prints? I am using SAP via an external Citrix connection and printing to a local printer.
What is the difference between AL08 and SM04 and SM51?
I want to get into a Facebook account but I don't have the password to it, just the email. Can someone please help?
Does anyone know if there's a way to check if a table exists in MySQL (possibly through PHP) without throwing an exception? It's not beneficial for me to parse the results of "SHOW TABLES LIKE." There must be some sort of query I can use.
Respected sir, Unfortunately the hard disk of my system is damaged, now I recovered my database. but it cannot be attached again to SQL management studio 2005. The error is myfile.mdf is not a primary database file. (SQL server, error 5171) Please sir help me.
I have a formula that adds a field formatted as 1.00 to another field formatted the same 2.00 and then deducts a third field formatted the same 1.00 which has a result of 2.00. How do I format the result to be 2 I have tried rounding, truncate, totext, fix but the do not work. Working on Crystal...
Hi, I'm new to a staff who maintains a AS/400 system in my company. How to avoid user login to Subsystem beside QINTER, because I'm still see user can login to QBASE. I want to maintenance user only login to QINTER but specific user can only login to QBASE.
I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des
Hello everybody! My father had deleted the photo on his phone. I am trying to recover them, but I cannot connect the phone as a physical drive. It appears as a network drive. How can I do that? I have Windows 7 ultimate. Thanks to all.
I would like know how to to use the Dataq. Please send me examples in RPG ILE/400 as possible. Thanks
We are currently creating purchase orders with a printer file overlay. Now we need to be able to email the purchase order. (Without printing it first.) We have the ability to email spooled files. And, of course, resources are limited.
I work in the IT department of a college campus and I have several out look users who's calendars are not updating correctly for all users. This is causing a lot of scheduling problems. Some are running Outlook 10 and some are still on Outlook 7. The server is an Exchange server and we also run...
How do you print barcodes on a Ricoh Copier in RPGLE?
I have 3 relating part numbers for the same part with the same description. How do I enter them into an Access DB for tracking?
I need to compare two files (Previous data and current data) with same fields but changed in some fields value in Current sheet. I want to compare both files and filter only those records which are changed. Ex. Previous Data: Reference name Address contact 123A Jhon USA 123 123B Paul UK 457 123C...