• SQL SERVEUR 2005 SISS AND WHERE statement

    I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it's work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0x80131937

    Sqlbeg5 pointsBadges:
  • SQL Find a number between the given ranges of number / Find a row which has range of given number

    I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value in...

    Bsethi245 pointsBadges:
  • Any softphone supporting phone number as parameter?

    I want to use softphone in my java application. Instead of typing or entering the number, is there any softphone providing facility to pass phone number as parameter or value? or can we use phone number as links, which will direct to the destination?

    987615 pointsBadges:
  • ILE Call(e) error handling

    I am calling a CMD from an ILE program (simulates WRKSPLF) that emails a spool file. In my program I use Call(e) and %error indicator is on when CMD is executed if an error occurs during execution however I cannot determine which error happens. I tried using psds sds msgid 40 46 msgdsc 91 170...

    filuphaze475 pointsBadges:
  • Conditional processing in embedded SQL

    I'd like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = 'AgtMaster' C+ Then C+ Fetch Next From...

    Cwc4,290 pointsBadges:
  • PE Production environment

    When configurinf a new account how to change from quality environment (QE1) to production environment (PE1) in SAP

    Msilva5 pointsBadges:
  • run oracle 9i with Windows Server 2003 Domain Controller

    sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like SQL....

    Swapnesh15 pointsBadges:
  • SQL Error

    SQSQL Error :Component SARWFNUM:SQLSTATE 37000L Error :Component SARWFNUM:SQLSTATE 37000SQL Error :Component SARWFNUM:SQLSTATE 37000

    Odunsi5 pointsBadges:
  • Does Apache POI-XSSF support Excel 2007 runs under Java 1.4?

    Hi Guys, Is Apache XSSF POI supports java 1.4 to upload the Excel 2007. Thankx.

    Ansipar288315 pointsBadges:
  • Microsoft Access menus

    How do you setup menus using MS Access?

    Danljonessr10 pointsBadges:
  • Converting a varchar to a numberic in SQL query

    How can we convert a varchar field to Numberic in a SQL Query in db2 400?

    AS400 - Ask the Expert485 pointsBadges:
  • Crystal Reports 8

    To Change The position & property of the Text in the crystal report from VB.NET code itself.... is It Possible??? while the Crystal report connected..... By Raam87

    12015 pointsBadges:
  • Round GPA to tenths and remove decimal in SQL

    I have a field in a table, ACT_OVGPA that represents a student's current overall gpa. The field is a 2 digit number on a scale of 00-40 where I believe there is an implied decimal point and actually represents 0.0 - 4.0. This is what I have written, but it returns an error "too many values". Can...

    Cmyers40 pointsBadges:
  • What do the standard numbers mean in the National Electrical Code?

    What do the standard numbers mean in regards to the National Electrical Code (NEC)?

    NetworkingATE1,545 pointsBadges:
  • How organizations deal with network design for disaster recovery

    I am looking for some information about how organizations deal with network design for disaster recovery. Specifically, my issue is about DNS domains, and whether to have a single network with a redundant warm site in a single domain shared by production processing, requiring unique IP addresses...

    NetworkingATE1,545 pointsBadges:
  • How do you tell Workflow to send an email to the initiator’s manager?

    I'm trying to create a workflow that will send an email to an employee's manager when that employee creates an expense report through the Portal. I've got the workflow set up and it currently sends to me when an expense report is created. So that part isn't really an issue. The issue is how do I...

    alm12180410 pointsBadges:
  • Finding the 3rd highest in the table using SQL.

    The table name is 'Employee' with the columns Empname Sal Age A 8000 25 B 7000 24 C 6000 26 D 9000 25 what is the syntax used to find the 3rd highest. I have tried with all the syntax but no gain. I have searched in w3schools.com but was not able to find the right answer. Kindly help.... Reks

    19757910 pointsBadges:
  • SQL Query

    Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ---------- ---------- -------- 1 3 01-12-08 1 2 01-12-08 2 3 01-12-08 2 2 01-12-08 3 6 05-12-08 4 10 05-12-08...

    Mariane10 pointsBadges:
  • Does similar ClearPool() from .NET Framework 2.x exist in .NET Framework 1.x

    I'm looking for a method similar to the ClearPool() from .Net Framework 2.x but this method must work in .Net Framework 1!

    alessandro.panzetta9,725 pointsBadges:
  • How to test Application scalability?

    What are the factors that need to be considered to test the scalability of the system? How do we ensure our application is scalable?

    Saimadhu455 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