• SQL average command for column IDs

    For SQL, does anyone happen to know if I can use the SQL avg() function for average by my column IDs? Basically, I have several different IDs and I'm trying to get the average of each through one query. How can I go about this?

    ITKE435,970 pointsBadges:
  • SQL Connect to remote system, run retrieved data on local system problem

    I need some help with the syntax required to build the SQL commands (embedded into an RPGLE program) that will do the following: Connect to a remote system (using a userID & password passed into the program as parameters). Dynamically build ALTER commands based on data SELECTed from a table on...

    mikechance8126325 pointsBadges:
  • IN and Exists in SQL?

    What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

    Prcvjr220 pointsBadges:
  • Advantages and disadvantages of certain SQL commands

    Where can I find information about the advantages and disadvantages of using SQL commands like BCP, BULK INSERT, SELECT INTO, etc.?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL command to remove number from within a character string

    What is the SQL command to remove a number from within a character string, when the number repeats later in the string? For example, '10PtreeGB-m1 01-01'. I want to remove the 1 after the m, but leave the rest of the characters unchanged (before and after)?

    mskent5 pointsBadges:
  • One doubt on SQL command “Like”.

     Hi One doubt on SQL command \"Like\". File 1 File Name:- A1 Filed(A1F):- 10 0  Zoned File 2 File Name:- A2 Filed(A2F):-  30 Character Please help me to search the data from file 1(A1) field data(A1F) value is present or not on file 2(A2) filed (A2F). I need to search multiple data from the pf...

    amalrajvs20 pointsBadges:
  • Save SQL commands in a CL?

    How can I save SQL Commands in a CL?

    Pt0505145 pointsBadges:
  • How to write multiple SQLRPGLE records into a printer file

    C/EXEC SQL C+ SELECT DISTINCT(CTP),COUNT(*) INTO :$Ctp,:#Ctotl FROM CUSTPF C+ GROUP BY CTP C/END-EXEC CTP is CustomerType in Customer File. Here actually I am getting 3 records as output. But I don't know how to write those 3 records into a printer file. Can anybody explain me how to write the...

    Sasikumarr200 pointsBadges:
  • inserting many columns

    i want to insert new columns like day1, day2, day3, etc. in a database by passing a veriable in day(n), please help me what i can do for this

    noor6125 pointsBadges:
  • Is it possible to give a user access to sql screen wherein he is allowed only to use select commands

    Is it possible to give a user access to sql screen wherein he is allowed only to use select commands. We have a team of users who use a set of 10 - 15 select commands on daily basis.

    JohnsonMumbai1,360 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:
  • SQL WKS SELECT COMMAND

    Thanks for your response. Actually i am using Oracle 7.3.1 with Devloper 2000 I want to get information from a table name ‘bilmst’ having column name ‘a/c no.’ and ‘enterdate’ i want to collect information as follows fy 01-07     No of A/Cs to 30-06 2005-06        1500...

    235235235250 pointsBadges:
  • I want to delete records from a PF outside a PGM

    I need to either setup a SQL that lets me pass a variable so that I can delete records based on a moving date. Or, I want to setup a CPYF command that will allow me to copy records that are *LT a variable (date). I'm not sure how to pass variable to either idea.

    TIB5 pointsBadges:
  • SQL command question

    I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don't know...

    Ktoby55 pointsBadges:
  • Parameter Date Conversion in SQL 2000

    my code is : string sql="insert into dummy(date)values(@date)"; sqlcommand cmd=new sqlcommand(sql,con); cmd.parameters.add("@date",sqldbtype.datetime).values=maskedtextbox1.text text; cmd.executenonquery(); the problem is it's throw and error like  conversion of varchar to date; Note :- my demand...

    Maheshwag260 pointsBadges:
  • SQL problem: Adapting code fragment

    How do I adapt the fragment of code below to show: a) Two columns - the Filipino Population and the Total Population  b) The Filipino Population as a percentage of the total population  SELECT DISTINCTROW POPDATA.CITYNUM,  COUNT(*)FROM POPDATA  WHERE POPDATA.ANCNUMBER=720  GROUP BY...

    Mentos5 pointsBadges:
  • SQL Server 2008 Code to find fields containing similar text

    I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word "Smith" Field 2 has "Smith AB" in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 Thanking you in advance

    Davewaltonuk20 pointsBadges:
  • SQL Server table structure

    Hi, i want to know is there any command other than SP_help or SP_columns to see the STRUCTURE of TABLE.

    Tablestructure15 pointsBadges:
  • 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:
  • Retreiving AS/400 SQL scripts

    When I start sql on our iSeries, the system returns my previous scripts I have run. Which fle do these live in in the iSeries and can I report on them?

    Morticia00110 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