Questions & Answers

  • Calling an Oracle stored procedure in Java

    In my Oracle database, I have this stored procedure: procedure getInfo ( p_ids IN IDS_TABLE, p_details OUT cursor ) Here's what the IDS_TABLE means: create or replace type IDS_TABLE as table of IDS create or replace type IDS as object ( id1 NUMBER, id2 NUMBER, id3 NUMBER ) Would it be possible for...

    ITKE352,430 pointsBadges:
  • SQL Server Query

    How to find the second highest value in a table using a Query. For example, in a table of employees how to find the second highest salaried employee.

    Radhika0 pointsBadges:
  • What’s the easiest way to test an Oracle stored procedure?

    We've been working on an ASP.NET project that's using an Oracle database. We've been using TOAD to add and manage stored procedures. This is where the problem lies....we're having too much trouble testing an Oracle stored procedure. Here's an example of one of our stored procedures: CREATE OR...

    ITKE352,430 pointsBadges:
  • Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Sameera5 pointsBadges:
  • using group by by joining 2 tables SQL

    there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

    Lak5 pointsBadges:
  • SQL question

    One table named as employee has 3 columns (name, salary, department). I need to retrieve the employees whose salary is greater than average salary of their department. that is name    salary   department iioo      10000    Technical aaaa    15000     HR pppp    17000    ...

    Hema19865 pointsBadges:
  • User profile cannot be loaded on my PC

    How to solve to my PC question. My user profile cannot be loaded. What should I do?

    Ariful1115 pointsBadges:
  • ActiveSync/Mail for Exchange : Display name not sync with gal

    SBS 2003 (Exchange 2003 sp2) Hi, I installed an SBS 2003 and all work fine. Now, I have 2 smartphone: 1 nokia and 1 htc (wm6.1) For nokia I use Mail for Exchange to synchronise mails, contacts and calendar For htc, I use ActiveSync. All sync works fine *** but *** I have 1 issue: * I defined some...

    Jmiranda75 pointsBadges:
  • Batch File for displaying popup window with a message

    Please a simple batch file for displaying a popup window with a message Thanks

    Jjjjjjjj95 pointsBadges:
  • Linking Crystal Reports

    Open Report - No Saved Data This report file does not contain saved data and cannot be viewed. New install of CR 2008 viewing report over vender database. How do I link data to reports I write?

    NIK11115 pointsBadges:
  • Database Views in SQL Server

    When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database.

    Jwcurrier30 pointsBadges:
  • How to create tasks in Exchange Web Services MAPI

    I'm pretty new to EWS MAPI and I'm having some difficulty with how to create and managed tasks. I've figured out how to create a task for myself with a problem but here's where I'm stuck. I can't create a task and assign it to another user. Can't interrogate the status of the task (percent...

    ITKE352,430 pointsBadges:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to extract data from SAP APO to BW (Not APO’s)

    Hi all, The APO system has many data sources. I have activated all the datasource with TCODE RSA5. I want to extract APO data to BW (Not APO's),where the APO data come from for BW extract. APO BW? SAP transparent table of APO? APO liveCache? Please help me. Thank you very much.

    BwConsultant10 pointsBadges:
  • i have a Exchange server 2003, and for some reason the public folder store has dismounted. However when i try to mount it i get the error message

    i have a Exchange server 2003, and for some reason the public folder store has dismounted. However when i try to mount it i get the error message

    Peace5 pointsBadges:
  • Configuring Outlook Anywhere

    Steps required to configure Outlook Anywhere using a single Exchange 2007 server and Outlook 2003 clients

    TheUKITGuy10 pointsBadges:
  • Exchange 2003 Dismounted Stores

    Is there a way to have exchange 2003 alert you when a store dismounts?

    Tnr31tech5 pointsBadges:
  • AS/400 remote access

    Hi, I am having a static IP configured to the AS/400 at the client site. But I can't able to connect to the AS/400 using iseries navigator from my site locally. But when I am using the TN3270 plus as telnet mode I ma able to connect it. So please help me in resolving this issue. the error showing...

    Naveens140 pointsBadges:
  • Retrieving public folders and sub-folders in Exchange Server 2010 using MAPI

    Would I be able to retrieve all items from public folders and sub-folders in Exchange Server 2010 using the managed API? Here's what I have so far: rootfolder = Folder.Bind(service,WellKnownFolderName.PublicFoldersRoot); rootfolder.Load(); foreach (Folder folder in rootfolder.FindFolders(new...

    ITKE352,430 pointsBadges:
  • BitLocker and Business versions of Windows

    BitLocker drive encryption is intriguing and important, but it's available only in Vista and Win 7 Ultimate and Corporate editions. Since these are the most expensive versions of the OS, most smaller companies use the Business version of Windows--what are some encryption options for them? As a...

    SearchMidmarketSecurityATE150 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