Questions & Answers

  • Can I replicate the ROW_NUMBER() in MySQL?

    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...

    ITKE346,080 pointsBadges:
  • How to create a MySQL pivot table

    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...

    ITKE346,080 pointsBadges:
  • Ethernet connection problem

    "Ethernet doesn't have a valid IP configuration." This delays the connecting to the Internet. How can this be fixed?

    pennyschinktgen15 pointsBadges:
  • How to use my computer as a phone?

    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?

    Ezias2775 pointsBadges:
  • How can I remove extra hard drives?

    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...

    huge32115 pointsBadges:
  • Printing reports from SAP

    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.

    Thenewbie715 pointsBadges:
  • SAP: What’s the difference between AL08, SM04 and SM51?

    What is the difference between AL08 and SM04 and SM51?

    boabdul6155 pointsBadges:
  • Getting into a Facebook account

    I want to get into a Facebook account but I don't have the password to it, just the email. Can someone please help?

    Briannalovesyou175 pointsBadges:
  • How to check if a table exists in MySQL without throwing an exception

    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.

    ITKE346,080 pointsBadges:
  • SQL Database is corrupted

    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.

    shampur5 pointsBadges:
  • Restore my Nokia 6300

    I want to restore my mobile Nokia 6300 but I forget our security code. What should I do?

    abhishekkumartiwari5 pointsBadges:
  • Format results of a formula

    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...

    rose123465 pointsBadges:
  • Avoid user login to subsystem beside QINTER

    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.

    rendyr5 pointsBadges:
  • How to uninstall OracleserviceXE

    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

    Desjacks5 pointsBadges:
  • Recovery deleted photo (without SD card)

    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.

    sdmirt20 pointsBadges:
  • Examples of data queue in IBM AS/400

    I would like know how to to use the Dataq. Please send me examples in RPG ILE/400 as possible. Thanks

    Aarancibia15 pointsBadges:
  • Is there a way to show a printer file overlay in spooled file? I need to email a document with an overlay.

    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.

    ItsHer20 pointsBadges:
  • Shared Outlook calendar not updating

    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...

    DaveITGuy5 pointsBadges:
  • Printing barcodes in RPGLE

    How do you print barcodes on a Ricoh Copier in RPGLE?

    sabatinofm10 pointsBadges:
  • Multiple numbers for the same part in Microsoft Access

    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?

    vaustin5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following