• I NEED SQL COMMAND TO EXTRACT THE NUMERIC VALUSE IN BETWEEN THE STRINGS

    VCH:FR:AUD/120.18/51.26YQAC/1.35QKAD/14.47QRCO/14.47QREB/1.35QKSB/6.00WGSE/20.91UOVZ I NEED TO EXTRACT THE VALUES IN THE ABOVE STRING AND SUMM ALL THE VALUES USING SQL COMMAND EX:120.18+51.26+1.35.....IN THE ABOVE GIVEN REFRENCE

    UUKKY15 pointsBadges:
  • Sound from .net

    how can I save and retrieve sound wav files to and from sql database using vb.net?

    Semauel8515 pointsBadges:
  • Migration from Paradox to MS Access or VB.Net/MS SQL

    We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated.

    ScotE45 pointsBadges:
  • SQL transcation log file

    Hi there, I developer is building a commercial application for me.  We are stuck at some point that we seem unable to deal with. The application being built is capable of dealing only with tables with primary keys.  We need it also to handle tables with no primary keys.  For clarity, we have no...

    Yba5 pointsBadges:
  • Simply, How do I populate Fields from a SQL Statement in Oracle Apex?

    This is not a facitious question.  I am new to APEX.  I have looked over this stuff for weeks, but I can't find a way to run an SQL statement and populate text boxes. I have tried the famous "For C1 in (Select..." but, when I put it into any of the areas, the event never sets off.  I've tried...

    Ddape20 pointsBadges:
  • as400 sql – non numeric data in numeric field

    is there a function I can use to avoid and abend when sql hits a numeric field that contains non-numeric data. sql: select * from LPDtst/ARCOMB WHERE ACAOF# <0 Error: Selection error involving field ACAOF#.

    oldpgmr75 pointsBadges:
  • On the as/400 i series can one use SQL querys to update file

    Cobol uses some kind od IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be...

    nitzinger385 pointsBadges:
  • Retrieve data from Oracle9i to SQL server

    Currently my database client using SQL Server 2005 and there have another database whereby is using Oracle 9i, I wanted to retrieve the data from the oracle whereby query in SQL server 2005. 

    Xue8715 pointsBadges:
  • SQL to insert comma-delimited string value to table column

    I have string like '1,2,3,45,6,7,8' I want to insert each comma separated value in a table column...my output look like this: COLUMN 1 2 3 45 6 7 8

    231219835 pointsBadges:
  • View t-sql SPID is executing

    Is there a table that I can query to view what sql statements a spid is running? I do not want to use the dbcc inputbuffer.

    Rick Martinez585 pointsBadges:
  • SQL saving off data created to copy into new database

    Data is created in one SQL DB for testing and then a new DB is created. Is there a way to save the data you need for testing in the new DB, so you don't have to create it each and everytime for testing?? Any suggestions would bew appreciated.  Thanks...

    Flyershockey25 pointsBadges:
  • Optimizing/Indexing to find last transaction

    I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...

    MODMOD0 pointsBadges:
  • Microsoft servers software and hardware upgrade

    We have the following architecture: 2 Microsoft SQL servers. OS is windows 2000. SQL database  is 7.0. The server hardware is HP proliant 800. The server is a SQL applicaiton server. The server is used for data mining. RIght now it has a script that used bulk inserts to push "csv" files to the...

    Techzon1225 pointsBadges:
  • sql what is TOSTMF

    In SQL what is TOSTMF for an output file, and how do I use it?

    GlendaBennett15 pointsBadges:
  • SQL Dumper library failed to

    How can I get by the Log on to Windows page when I have SQL Dumper library error message?

    Drhalss5 pointsBadges:
  • Running a job in SQL 2005 by calling a batch file from a As400 CL program

    Hi, I already asked this question before but did not get any reply. Anybody please help.. I am calling a job on AS400 which uses RUNRMTCMD to execute a batch file on sqlserver 2005 server. This batch file uses sqlcmd command to run a job on sqlserver. When I execute this batch file manually from...

    Gullu15 pointsBadges:
  • Pros & cons to have a typical star schema but with only one fact value field and a thousand attribute names in one of the dimension tables?

    Want to build a kind of a scientific fact search and analytical engine for a lot of different types of measurements hosted in a lot of source tables and columns. A star join schema is built and data is copied (ETL) from the sources as usual - but all source column values are stored into a single...

    Rwg30 pointsBadges:
  • Accessing an Access DB from Outlook via VBA

    Hi The situation: In Outlook I get a message from a server. The content of the message needs to be put into an Access db. But, there may not exist another message with the same date. So, I need to look into a db if there is already a message with the same date and time. If there exists one, then it...

    Camastanta50 pointsBadges:
  • Physical file over 600 000 000 records

    Hi We have a Physical file which has more than 60 million records in it. In our application we search for the particular records based on 6 fields as a search criteria (web based) , search process are done in SQL Procedures. Even when i creatd a LF based on the mandatory search fields , we get  a...

    As400programm10 pointsBadges:
  • embedded sql update

    I have a prog that should update all KY cust master records with the new code AR. I run the program but nothing happens. The file remains unchanged. I am new to embedded sql so what am I doing wrong ?? D OLDWH           S              2    INZ('KY')    D...

    ToddN200015,605 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