• Free SQL software with interface to enter data

    Hi, I need to enter about 5000 lines of data with about 10 columns. and then I would query the data (by lets say SQL, but I'm open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view only that data...

    Maqib1005 pointsBadges:
  • How to create date in SQL Server 2000

    I created a table with attribute date and i want to store date as "Date-Month-year". What procedure to create a date and how we able to insert the required format by using SQL Server 2000?

    Malikjavediqbal30 pointsBadges:
  • Building an xml in java

    Please give me an example of building an xml with multiple child nodes, in java. I want something like : <Parent> <Child1>something</Child1> <Child2>something else</Child2> </Parent> Now, the values for Child1 and Child2 must be picked using SQL from AS400....

    Siri55 pointsBadges:
  • Connectionstring for paradox db password protected

    Hello everybody, Searching for answers I've found this interesting page!! I've created a SQL query to a paradox database, it works fine with a non- password protected table: Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended...

    Starbasestarfleet20 pointsBadges:
  • Automate TSQL Query Output

    I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?

    Eabouzeid175 pointsBadges:
  • SQL query

    I have a table like this... emplid   qualification 101           b.tech 101            java 101            cpp 102            java 102            sql I want the output as: emplid      qualification1       qualification2          qualification3 101      ...

    raghib5 pointsBadges:
  • Writing a SQL query for an Oracle table

    We have this data in an Oracle table (here it is below): MONTH VALUE 1 100 2 200 3 300 4 400 5 500 6 600 So we need to write a SQL query so the results are showing like this: MONTH_JAN MONTH_FEB MONTH_MAR MONTH_APR MONTH_MAY MONTH_JUN 100 200 300 400 500 600 Any help would be appreciated.

    ITKE435,920 pointsBadges:
  • Comma Separated values using XML PATH in SQL Query

    Hi This is my first time to post my complex query here I am facing the critical problem for comma separated values in the column using XML PATH Let me explain you in brief now I have a table CallDetailReport table with below mentioned structure which stores values like CallStartDateTime[DateTime]...

    cnu12525 pointsBadges:
  • Receiving ORA-00918 error when running SQL query

    In Oracle, I keep getting this ORA-00918 error: Column ambiguously defined when I'm running this SQL query: SELECT * FROM (SELECT DISTINCT(coaches.id), people.*, users.*, coaches.* FROM "COACHES" INNER JOIN people ON people.id = coaches.person_id INNER JOIN users ON coaches.person_id =...

    ITKE435,920 pointsBadges:
  • Oracle SQL Query

    I have created two tables. One is Item_Master table with the fields Itemno having Primary key and must begin with letter ‘I’, Item_Name(HDD, MONITOR, CDROM, KEYBOARD, UPS), Stock defined as Not Null and Price which is greater than 10000 and less than 30000.Another table is Item_Trans with the...

    RaviMangalore5 pointsBadges:
  • Compare two file data row by row in SQL

    I need to compare two files (Previous data and current data) with same fields but changed in some fields value in Current sheet. I want to compare both files and filter only those records which are changed.  Ex. Previous Data: Reference name Address contact 123A Jhon USA 123 123B Paul UK 457 123C...

    sgautam11115 pointsBadges:
  • I want to parse data from one field into two based upon criteria.

    I have lots of data with disparate information in one field and I need to take all information to the right of any * that might appear into a separate field? There will be an * about 10% of the time. Examples of the field in question. Example 1: CKD Stage I ****250.40/585.1 Example 2: /Prosthesis...

    JohnSouthFlorida5 pointsBadges:
  • How to I write a SQL query to ignore case in a Oracle database?

    In my Oracle database, I have a SQL query that I want to ignore case. See below: SELECT * FROM TABLE WHERE TABLE.NAME Like 'IgNoReCaSe' So if I want the query to return either "IGNORECASE", "ignorecase" or a combination of them, how can I do that? Would that be possible?

    ITKE435,920 pointsBadges:
  • Can I do a MySQL dump by a SQL query?

    Can I do a "mysqldump" by a single SQL query? What I basically mean is that I want to dump the whole database. Thanks so much!

    ITKE435,920 pointsBadges:
  • Help with SQL query

    Dear friends, I am working on squirrel and wrote a query which is like this: select sum((coalesce((Sent_128),0)))*(365/(count(distinct(date_created))))/(((sum(coalesce((quantity2),0))/(count(distinct(date_created))))+(sum(coalesce((qu antity),0))/(count(distinct(date_created)))))/2) as "final" from...

    animeshdubeyad5 pointsBadges:
  • What’s the best SQL Query Formatter tool?

    Hi experts, Is there any free SQL query formatter tool? I am using this free SQL Query Formatter Tool for small queries. It is very good tool. But I can not customize everything what I would like, like fonts and colours. Is there any other good free tool?

    sulica685 pointsBadges:
  • Multi-member file in AS/400 (SQL query)

    On my AS/400 in an interactive SQL (5250 session),select * from myfileonly returns rows from one member when "myfile" has more than one member. But how can I get rows from a specific member? Thanks for the help!

    ITKE435,920 pointsBadges:
  • RUNSQLSTM

    Hi All, My below SQL query is running fine: - SELECT a.USRP,a.USER1, SUBSTR(a.USER1,23,3) as Template, BRCB, b.MGRP,b.ICDE,INAR,a.SECL,ACA1,ACA2,ACA3,ACA4,ACA5,ACA6 FROM muserdd as a left outer join MACBRDD as b on a.USRP = b.USRP left outer join MITEMDD as c on b.MGRP = c.MGRP and b.ICDE = c.ICDE...

    6r1,850 pointsBadges:
  • DB2 reorgchk current statistics on table all

    With help of below query we are getting output for all tables and indexes  "db2 reorgchk current statistics on table all". But I want only those tables which we can reorg on that tables like *---*,--** etc..... Please provide me SQL query where I can see only that tables name where they require...

    tusharhande85 pointsBadges:
  • DB links

    Please provide a generalized SQL select query to find out which remote database we are connected to using a database link.

    ssk25010 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