• Sql Search

    Hi, I have a Search box on my site at top. Where visitor can enter any keyword. I have Full Text Search enabled on my DB and index the Columns. I have one Columns SalesTitle in one of Table Catalog.Product, which contains almost our required keyword, like ProductNumber, Description, BrandName,...

    Mr. SEA130 pointsBadges:
  • how to store the radio buttons checked value in a database (sql)using vb.net

    Iam having 2 radiobuttons in my web form rbown and rbrent for the user to selcet whether he owns a house or he rents.I assigned own and rent as text propertis to the 2 radiobuttons and groupname as group1. Iam trying to store the text values depending on the selection of the radiobuttons in the...

    Anupamak1515 pointsBadges:
  • Using Decode in oracle sql query for Debtors Analysis Report

    i have a table called transactions in my oracle database which stores data for employees under particular employers. each member has an account and employer_id with transactions , the table has fields as below. TRAN_ID, TRANTYPE_ID, PENSION_ACCOUNT, EMPLOYER_ID, TRANAMT, SALARY, TAXEDAMOUNT,...

    wiri5 pointsBadges:
  • SAP HRP 1000 & 1001

    Hi For a recent Datawarehouse building activity, we'r to pull data from one of the SAP HR System to our SQL Database. I'm not much familiar with SAP and hardly have any idea about SAP internal architecture and I need ur help thus. I was told HRP 1000 Has all the object details and HRP 1001...

    Mkiva5 pointsBadges:
  • Training- SCOOP Inc.

    I'm thinking of taking some training from SCOOP Inc. They offer iSeries training (Java, SQL, RPG etc.). Have any of you taken training from them? If so what did you think? Pros? Cons? Would you recommend them? Let me know. Thanks!

    Dantheband0 pointsBadges:
  • ABAP/BI career.

    Hi, I have total 4 year of exp on ERP development & customization with sql dba & 1.5 years on sap-abap. at present i am working as sql dba. i want to change my current sql dba profile to SAP. Please tell me which is the best option for me sap-abap or sap-bi or sap-bw. is sap-bi or sap-bw are the...

    NitinVarshney20055 pointsBadges:
  • RE: SQL Restore Error (SQLSTATE 42000 “Internal Consistency Error”

    Hello All, I am in need of some advice. We recently had a database go down and become corrupted. When I went to restore I receive the following error (Title Bar: ODBC SQLSTATE42000, Message:Internal Consistency Error, contact technical assistance...... I did have this happen once a few months back...

    Wingis0 pointsBadges:
  • Transform rows to files in an SQL statement.

    Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT  from table CLIENTES (sql against qsys2/syscolumns).   SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = 'CLIENTES' AND TABLE_SCHEMA = 'MANEL' Observe vertical orientation. Column 1 Column 2...

    I40075 pointsBadges:
  • Difficult SQL query, is this possible?

    Two tables, First Table --FN---LN----Reasons John | Doe | 6 | Jane | Doe | 2 | ----------------- That's the end of the first table. Second Table ---Reason----Reason Detail----- 2 | Invalid SSN 4 | Invalid Date Of Birth -------------------------------------- That's the end of the second table....

    David Phillips35 pointsBadges:
  • sql query

    any one explain this query: select regexp_substr(char_name,'[^,]+',1,level)as row_id from char_change connect by level<=(select length(replace(char_name,',',null)) from char_change); this query is used to get the string value and print the row wise.

    Gowriking65 pointsBadges:
  • Avoid Dulpicacy while entering Data in SQL db using VB6 as front end

    Iam beginner in Vb & SQL. I am entering data like MemberName(txtMemberName.text) in sql database through VB6 front end form. I can enter same data in this field. Can any body help me in avoiding the duplicacy of the data. Following is my code on Save button :- Private Sub btnSave_Click() If...

    ITAdministrator5 pointsBadges:
  • SQL Update not Working using two files

    I have attempted to update one file with data from another but I am getting two different errors depending on how I enter my statements. I used information from this site as a reference for these statements but I must be doing something wrong. UPDATE DABCON2/ACTPHY01 A SET A.B1N4CD = (SELECT...

    dab77780 pointsBadges:
  • New Contest: ASK, Answer and win some Amazon.com gift cards

    It's that time again -- a chance to win an Amazon.com gift certificate based on your activity in the IT Knowledge Exchange community! Remember: the more you ask, answer and discuss questions, the more Knowledge Points you will earn. (Only valid questions, answers and discussions will be counted...

    ITKE346,360 pointsBadges:
  • VS 2005 SQL Reports – Need to convert 5 character string to datatime

    Hey there. I am relatively new to SQL and have a problem. I am building a report that gets a summation of a column called 'Duration'. The datatype is char(5) e.g. "00:30" to represent a half hour. I suppose I need to change the datatype to sum it but can't figure out how to. What would my query...

    Haxatron15 pointsBadges:
  • How to search more than a word in a column SQL database?

    i have an array of words to be search in my sql database like: searchword = array(['Arrays','Logistics']) for word in searchword:     conn.BeginTrans()     cursor = conn.Execute("SELECT idf FROM instance WHERE instance='"+ word +"'")     conn.CommitTrans() but some of the searchword cannot be...

    Semantic855 pointsBadges:
  • Update SQL Server 2005 Scripts

    I don't right code & don't have the confidence to try on my own so, I'm asking for help. I need to run an update script to clear out the data from iweb_conf_demo.Attendee_ribbons.Then I’ll need to run multiple scripts to update multiple records on the same field iweb_conf_demo.Attendee_ribbons...

    DJandLO130 pointsBadges:
  • SQL REPLACE with pointer

    I need to manipulate xml-files larger than char-field max-length allowed with RPG.   [strong]Background info:[/strong] My current solution uses a char-field... My app stores XML-files in CLOB-fields. I copy the xml-file from CLOB-field to a char-field: I then use %scan to find relative position of...

    DanTheDane2,555 pointsBadges:
  • Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    DJandLO130 pointsBadges:
  • Updating a Date Time Field

    I need to update the Confirmation Date Time field to NULL for a specific meeting but am unsure how to insert it.  The script below works for an individual but if they have more than 1 confirmation date it clears then all. Meet_Master.MEETING is where the meeting code AM2011 is. UPDATE   ORDERS...

    DJandLO130 pointsBadges:
  • Querying against Views vs Tables

    I have a view that combine several tables, so that the view presents more information that each table taken individually. I want to write an "INSERT INTO ... SELECT ... FROM xxx" query. Should I use the View in that "FROM xxx" or should I expand what the view shows? What's better in terms of...

    Artaxerxes25 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