• Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • Need to create a bootable server 2003 CD

    Hello, I have a burned copy of Server 2003 Enterprise edition that a friend gave to me. I'd like to install it on my test server, but am unable to because the CD is not bootable. I have tried booting the server with a 98SE floppy boot disk but am unable to run setup through DOS. I currently have a...

    Kfettig5 pointsBadges:
  • Receiving undeliverable email we did not send

    Hi everyone, One of our users keeps getting undeliverable email messages. It looks like someone out there is sending mail and making it look like it is coming from him. Is there anyway to stop this? We are running Exchange 2007. I don't think it is relaying or a virus. It does this even when his PC...

    Fuddstud0 pointsBadges:
  • Group policy: Restricting users from accessing control panel

    I want to restrict users from accessing control panel from their workstation. How can I do that?

    Mulalo0 pointsBadges:
  • Loading CSV files into Oracle tables

    I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then use...

    Gaugelc0 pointsBadges:
  • Multiple DHCP Scopes for multiple VLANS

    I am using Windows Server 2003 as a DHCP server. I would like to have centralized DHCP management using the one server to give out addresses to each of the 3 VLANS. We are also using Cisco switches and I planned on using the dchp-helper to allow the DHCP packets to be forwareded to the server. I...

    Skepticals0 pointsBadges:
  • USB External Hard drive and Windows XP

    I have two issues which are basically the same. I have an external USB hard drive that I connect to a computer running Windows XP. Windows USB driver recognizes the hard drive and shows the drive in Device Manager but Windows does not show the drive in Windows Explorer. A customer has a USB FLASH...

    Cestanley0 pointsBadges:
  • Block IE or Internet access with group policy

    Is there any way to block Internet access with group policy? I am setting permissions for some of the machines locally to only allow certain users access to the IE executable, but that is a pain in the butt. I have: Win2k3 single domain with 2 DC's approx 50 XP Pro workstations. I'm guessing this...

    TheVyrys0 pointsBadges:
  • What are the biggest missed opportunities for SMBs?

    During the Gartner Symposium/ITxpo 2012, Raymond Laracuenta, managing vice president at Gartner, told SearchCIO-Midmarket editor Wendy Schuchart that one of the biggest challenges facing SMBs is their use of technology infrastructure to drive the business. Do you agree with his statement? What are...

    Michael Tidmarsh29,345 pointsBadges:
  • CostPoint MO subcontracts req

    Is there a way to do multiple reqs at one time withing CostPoints MO subcontracts requisition screen?

    jross5 pointsBadges:
  • Open IT Forum: IT’s role in customer service

    One of ITKnowledgeExchange's bloggers is working on a series about customer service in the enterprise, and how it can be improved. From the IT side, do you have any experiences or suggestions for improving how companies do customer service? We'll take horror stories as well! Help a fellow IT...

    MelanieYarbrough6,345 pointsBadges:
  • What’s your definition of a CIO?

    After years of searching, SearchCIO's Scot Petersen thinks he has found the answer of the mysterious question: What is a CIO? His answer: "So a CIO creates sustainable business value and drives growth in increasingly complex, volatile and competitive markets." Do you agree with this? What's your...

    Michael Tidmarsh29,345 pointsBadges:
  • IKM Business analyst assessment

    Can anybody help me with the IKM business analyst assessment / online test? I am looking forward to see sample questionnaire or areas covered under this test.

    pradhankasturi25 pointsBadges:
  • A manufactured part was over reported

    A manufactured part was over reported, so now I show 20 parts available in MAPICS that do not exist. How do I fix this?

    csunyap5 pointsBadges:
  • OOPS fundamentals test by IKM

    Does anybody have sample questions from the OOPS fundamentals test by International Knowledge Management?

    manu9175 pointsBadges:
  • What’s your opinion on the remote worker?

    In a recent blog post, MrDenny talked about the pros of working from home including: Fewer distractions, financial benefits and increased productivity. What's your opinion on the remote worker? Should companies allow more workers to work from home?

    Michael Tidmarsh29,345 pointsBadges:
  • What’s your funniest tech support story?

    We all know the old story of the tech support guy who was called to help with a broken mouse that the client was using as a foot pedal. But there are plenty of lesser known but equally humorous tales out there. What's your funniest tech support story? Who knows, you may tell it here and become part...

    Michael Tidmarsh29,345 pointsBadges:
  • Salary review

    How would you approach the topic of raises with your management (I'm looking for general ideas, but something unique)? Thanks

    Magna970 pointsBadges:
  • Upgrade to Oracle/Intel: Go Linux vs Windows

    We are planning upgrade our main database cluster (rs6000/aix) to Oracle on Intel, research done give a lot of papers from dell, hp, intel that about roi of moving out of risc/unix but there is no clear evidence about performance issues between LINUX and Windows Server as the selected OS. Do you...

    Romerogt0 pointsBadges:
  • Tech Support: Horror Stories from the Trenches

    Going into the IT field, we all had to start somewhere. Helping out at school on the website, fixing a friends computer, joining the schools computer club, but that was before you graduated to the job field. You now have your A+ and you have just been hired as a member of the help desk and you are...

    Harisheldon5,660 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