• evaluating a range

    I am trying to evaluate a formula to return a statement if true. I am having trouble with the syntax. I am working out the number of years service for staff using the formula currentdate-{employment date}/365 What I want to evaludate is whether the result is between 5 and 6. If true I want the...

    Gerrycan5 pointsBadges:
  • Updating a field and counting unique field values from another fields all in the same query?

    How can I structure the following query to allow me to count the number of unique entries in a field named "amount" and using the same query, update another field named "unique" Here is what I am doing: SQL = "select amount, count(amount) from tblmessagein group by amount having count(*) = 1" If...

    Grantp40 pointsBadges:
  • sql with windows vista home premium 32bit

    can i install sql programs in windows vista home premium 32bit

    Mayo5 pointsBadges:
  • SQL 6.5 Upgrade

    We recently upgraded an application from MS SQL 6.5 to MS SQL 2008. We took quite a performance hit. Is this to be expected?

    DickRich15 pointsBadges:
  • New CUM Level 8305 is giving me SQL Headaches

    We recently upgraded to a new machine at OS Level V5R4 CUM 8305. Our old machine was also at V5R4 but the CUM level was only 8057. Ever since the upgrade, I have been having SQL Problems. My latest problem involves trying to update a QTEMP File that was built using CRTPF and specifying a record...

    FCARPENTER200 pointsBadges:
  • sqlcode -727

    ANY ONE KNOW WHAT -727 SQL RETURN CODEIS?

    Bebiii15 pointsBadges:
  • How do I write a SQL statement to get all data from a table called subscrib?

    How do I write a SQL statement to get all data from a table called subscrib?

    Thechriseco5 pointsBadges:
  • Store Procedure Codes Please help

    I have a problem in SQL, and please expert helps me out and give me an advice of how to solve this issue. I have a main table where to store the data, I have mutliple columns and those are SSN, DECLEAREDDATE, SOMATICMCCLEAREDDATE, PSYCMCCLEAREDDATE, DESECONDCLEAREDDATE, SOMATICMCCLEAREDDATE,...

    Josephptran15 pointsBadges:
  • Matching External lists to your Database?

    Hello everyone, I work in a telco and manage the data in the company's CRM. I'm often given lists of company names by our alliance team, and asked to match the list against our database to see which companies already exist in the CRM and which don't. At the moment I can only accomplish this by...

    Nik145 pointsBadges:
  • SQL Writer library failed initialization

    SQL Writer library failed initialization. Your installattion iseither corrupt or has been tampered with. Please uninstall then re-run setupto correct this problem. How should I handle this?

    Valeverger10 pointsBadges:
  • Populating one combobox in Delphi 7 from another?

    I have one combobox in which you select an option. What is the sql used in the query to restrict the second combobox depending on the first value. All I seem able to get is: [SELECT Name_Of_Race FROM Races WHERE Name_Of_Allegiance = DBLookupComboBox1.Value] Here, when I press the button to set the...

    RavenMoon5 pointsBadges:
  • SQL query for obtaining answers

    Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given...

    Frs20 pointsBadges:
  • What is the difference between SQL and T-SQL?

    What is the difference between SQL and T-SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • STRDFU utility

    I would like to get the pre & Post image of changes when I update data using SQL. Currently I am getting this facility when I update thru STRDFU utility.

    Iamsubbarao60 pointsBadges:
  • Invalid objects after upgrade from 8.1.7.4 to 10G

    for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; EXCEPTION WHEN OTHERS THEN...

    DBAKim5 pointsBadges:
  • What is the difference between software package in SQL and PL/SQL

    why is the need of psql when the sql is already avaliable.

    Krrishkundan5 pointsBadges:
  • Video hosting

    I am including a video howto section to my business website. I have minimal experience in php and sql but have already created a SQL database for the information. I want this to be both dynamic and directable through the title of the video. can someone please give me direction.

    Tripodcomputerservices20 pointsBadges:
  • CRViewer Logon Failed error within Visual Basic 6

    I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few others,...

    Lamm10 pointsBadges:
  • Can you force a user input in a SQL statement, then have the statement continue running

    Hi, Can one in an sql statement , when run in sql, force a user input to be entered and when entered, the sql continues to completing

    Bugsy5 pointsBadges:
  • Embedded SQL in an RPG FREE program

    I am developing an on-line screen program, where the user can select a view of the data from a list of "views". This is my first crack at embedded SQL, Basically i issue the Prepare, declar the c1 scroll cursor, and then open c1, and then do the fetch. At this point I am loading the subfile. First...

    Merts30 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