• 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 =...

    ITKE346,470 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...

    sgautam11110 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?

    ITKE346,470 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!

    ITKE346,470 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?

    sulica235 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!

    ITKE346,470 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,520 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:
  • How to find a specific word in a SQL table

    How do you write a SQL query to find a specific word in a SQL column. Example: I want to show all records that have the word Bob in it but do not want to include records that are Bobby or Bobble etc., only the exact word Bob. Hope that makes sense.

    Boomer15 pointsBadges:
  • SQL Server 2008 SSIS Update Command Performance Issue

    Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB with 500,000 rows using a...

    Sflatbush60 pointsBadges:
  • Slow query response time in SQL Server 2005

    Why is their a slow query response time in my SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Union operator in SQL server 2000

    How to give where condition to the result of the query using Union operator?

    Jyoti198645 pointsBadges:
  • how can make this SQL Server query faster

    All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as '00', ISNULL (td1.price, 0) as '100', ISNULL (td2.price, 0) as '200',...

    Singhal120 pointsBadges:
  • Writing a specific query in SQL Server 2005

    I have a table called "ticketing" and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to schedule SQL query to run in Microsoft SQL Server

    I have a query that I want to automatically schedule to run daily. How do I do this?

    House5 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