• Measuring Software Development

    I would love to learn your best practices for measuring software development. Both project measures and how to measure development activities. Also, if you use agile development methods, do you use different measures and, if so, what specifically do you use? Thank you.

    Real Niel5 pointsBadges:
  • Query on Storage labs

    Hi, We are a Software product company exploring options to test our product offerings on EMC, Hitachi storage arrays. Having said this we are looking out for (commercial) Storage labs such as Veritest that enable fee-based access for external users/non-partners. Please have your advice on this....

    Mainstream0 pointsBadges:
  • Using SQL CLI APIs to call an sql stored procedure on an AS400

    I would like to know if there any examples of using the SQL CLI APIs in a COBOL/400 program that may help me in using the APIs to call a stored procedure and process the result set(s) . Thanks Mike

    I5DB2DBA5 pointsBadges:
  • Updating textboxes on a Userform

    How can I get real time information in a text Box on a userform when a macro is running

    Alanr5 pointsBadges:
  • Setting Local User Environment settings with VBScript on a standalone 2k3 server

    Is it possible to set TerminalServicesInitialProgram, TerminalServicesWorkDirectory and EnableRemoteControl via VBScript on a standalone server? I am getting “The specified directory object is not bound to a remote resource” error, code 80005009, Source: Active Directory.

    Crazybob5 pointsBadges:
  • Domino Unicode Conversion on the Web

    How do I display the unicode for chinese in a domino field in edit mode. When I create a new document from an XML file containing chinese, the unicode for the chinese is still showing in the field in edit mode when first editing. As soon as I save the document again, the unicode converts and...

    Spruce5 pointsBadges:
  • Deleting all formulas in a worksheet when unprotected in VBA code

    I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...

    Barnoldswick5 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Pointer In CL

    How we point the particular record in file on the base of key in CL Programming.

    Goyalp420 pointsBadges:
  • Retrieving values from a table in SQL

    I have values stored in a table in SQL this order: -99.4%, 99.5%, -99.6%, -99.7%, 99.8%, 99.9% I'd like to retrieve them in this order: -99.4%, -99.6%, -99.7%, 99.5%, 99.8%, 99.9% The ORDER BY clause does not do so. Is there another clause I could use?

    SQL Server Ask the Experts2,585 pointsBadges:
  • T-SQL Query- how to explode XML fragment stored as NText into table?

    I'm using a commercial storefront software that offers "extension data" fields as NText to store custom data. I am storing an xml fragment that looks like this: <priceSplit xmlns="http://tempuri.org/priceSplit.xsd"> <split> <type>Credit Processing Fee</type>...

    Lambrite5 pointsBadges:
  • email query recordset

    "I have a query (emailnotifytest) based on 2 tables . One table (shipmentdata) filters on new records. the other table (contact) filters which contains the email address filters whether the address is not null. The tables are joined by the companyname. the code below works as far as sending the...

    Roundy5 pointsBadges:
  • Concatenate

    I have a value in a column that I need combined on 1 line. I need a new row when the Id in the table changes. For example Column A Column B 1 Boyd 1 Honaker 2 Steel I need the row to be 1 Boyd, Honaker 2 Steel I can get the name column to concatenate but I get one large line. I can't figure out the...

    Musiclover5 pointsBadges:
  • EMC Clariion CX700 Problems – Data Sector Invalidated

    Hello, I have two EMC Clariion CX700's (which, for convenience we call CX700-1 and CX700-2) and one recently added CX3-40 in my SAN environment using fiber-switch fabric. Over the weekend, I experienced a hardware failure on SPA on CX700-1. After having it replaced by my vendor's technician and...

    UniCal0 pointsBadges:
  • Equallogic

    Hi, Just looking for people's experiences of using Equallogic SAN attached storage. Specifically - Performance - Interoperability - Cost - Competition - Management software Thanks in advance Noz

    Nozmeister00 pointsBadges:
  • MS Terminal Services Client Control (redist) not available when XP Pro Installed with SP3

    I recently loaded XP Pro on new machines using media with SP3. When I finished all MS updates, I attempted to access Remote Web Workplace (RWW) on our SBS 2003 (connect to client machines and/or server). I got a warning about my IE setting blocking the install of an Activex but IE settings are not...

    CASLIT75 pointsBadges:
  • Generating valid XML with a Lotus Notes View

    I am using XML generated by a Lotus Notes view in an AJAX application. The difficulty occurs when the value in one of the fields in one of the records in the view contained an ampersand. The resulting XML was then invalid. There should be a function @HTMLEncode which would work like the @URLEncode...

    McCulloch5 pointsBadges:
  • Not Return Any Record if Value Exists

    If I have a table that has the following data (f1 & f2 are the field names): f1 f2 a 1 a 2 a 0 b 1 b 2 b 3 I want to write a query that would not return b because b has a f2 = 3. So, in other words: I have a table with many records for each id. I do not want to return any records if the id has a...

    Rjwilcox45 pointsBadges:
  • SQL Text Match on Character Stream (wildcards)

    I need to match a text field on zero or more characters. If available, the 'or more' characters need to be in a specific sequence. The % wildcard doesn't quite cut it. For instance, I need to match the name with 'm', 'ma' or 'mar' (but no other character combinations). Is this possible?

    Ohreallyus5 pointsBadges:
  • Designing a report in SQL from an Excel worksheet

    I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

    SQL Server Ask the Experts2,585 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.

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

Following