• SQL 2005 trial version update

    I installed SQL 2005 trial version on a production server and the 6 months are almost up. I would like to go to SQL 2008 since I can get a very good deal for it. What options do I have? Can I just upgrade over the trial version or I need to uninstall 2005 and reinstall 2008. The 2005 is a trial for...

    Alan Dala30 pointsBadges:
  • Haversine formula in RPG or SQL

    I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?

    Brenger170 pointsBadges:
  • Prevent Update in DB2 SQL External Trigger Program

    I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a...

    Djswtd25 pointsBadges:
  • Insert superscript text into Oracle database

    how can i insert superscript or subscript text to the data base i have colomn called measuments Units and i want to insert quadratic meter M2 or Cubing meter M3 am using oracle 9i pleeez help

    Rosealzubi115 pointsBadges:
  • Webpage and SQL interaction

    The problem I need to figure out is that I need to have client information stored on an SQL server database and I need something to be able to use this information to get quotes from several insurance companies. All these companies require different info in a different order. So my questions are as...

    Katy20 pointsBadges:
  • Issue SQL Query with Localized String through PowerShell

    Hello, I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (') somewhere within the localized string. You can look at the following...

    Bgsullivan15 pointsBadges:
  • SQL proceedure to join header and detail file

    I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

    AS400 - Ask the Expert485 pointsBadges:
  • SQL help

    hiow to pick only alphbets in a string or a column using sql

    Ecsbc35 pointsBadges:
  • Ignoring fields in SQL Where Statement

    Can fields in a where statment be ingnored. Such as Where name = :name and date = :date, but if I just pass in a name I'd like the where to select only on the name and ignore the date.

    Charrdzc5 pointsBadges:
  • I need to display only last two characters

    i need to disply only last two characters in a column, the column data like this 1.3.2NE,1.2.2NN,1.10CE,1.11.1NN,10.3 for this i need output like this NE,NN,CE,NN

    Ecsbc35 pointsBadges:
  • Grouping the records in RPG

    How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??

    Shwesmile20 pointsBadges:
  • Return specific level parent

    Can anyone help? I have a table, with 7 records ID ParentID Level ------- ------------- --------------- 01 (empty) 1 A 01 2 BC A 3 X BC 4 B 01 2 DE B 3 Y DE 4 I need a query to return, for every record in the table, the corresponding 'Level 2' ID, excluding records with a Level of 2 or higher (i.e....

    Paulvian5 pointsBadges:
  • Facing a problem while working with transactions

    I m having my SQL server on Machine A and i m starting one transaction on server from Machine B, now in between suppost Transaction from Machine B creates a new record in one of the table on server using insert into statement, after creating the record the LAN connection of Machine B is...

    Rajratna5 pointsBadges:
  • SQL – SQL Data is not clearing

    Generated my sql data and proceed to load data into a subfile. It works great except for one thing every time i leave the program and return back into the program, my subfile is load with my last search criteria and i don't know how to clear the buffers or tempfiles or whatever sql does with its...

    Pablov45 pointsBadges:
  • Displaying SQL data in ASP.NET

    I've put data in a description field in SQL; how can I display it in ASP.NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Timed execute array or function

    Hello there I am new to sql and cold fusion I want to create a timepicker to execute an array of function at x time. whether in sql or coldfusion. Thanks in advance

    Ctc12320 pointsBadges:
  • QMF for Windows

    How can I execute 10 sql at one go ?

    Jams5 pointsBadges:
  • Embedded SQL

    I need to get a grip on using the embedded SQL in an RPG ILE program using the word "CURRENT" and I need to know how this works (in laymens terms please.)

    Chinadoll04149810 pointsBadges:
  • MIgration to 64-bit Sql Server

    What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?

    Tomfitzrugger5 pointsBadges:
  • Using answer as criteria in sql server

    I have a table that has a demand order and a supply order I want to search for a order in the demand order column it may have more than one supply order and then I want it to look to see if that/those supply order is in the demand column and if it is get the supply orders and so on. So essentially...

    Jeremyj545 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