• 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. Is there any other good free tool?

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

    ITKE54,755 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,485 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:
  • 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:
  • Improving the initial speed of a SQL query

    I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL query to find out policy numbers

    There are 2 tables POLICY and NAME. The relationship between POLICY and NAME is only the policy number. and their relationship is like many to one. I mean several policy numbers can have same name in the name table with that many records. Now my question is to find out the policy numbers having the...

    Deyyam0 pointsBadges:
  • SQL query project

    I am working on a project. If I enter the a/c no and I found correct then the companies name and their share values are provided to me. After that, when I buy a no of shares, I get the Transaction amount (no of shares*share value), broker value (1.5% of transaction amount), total amount...

    Creative495 pointsBadges:
  • SQL Query to return a single value for each record based on max FIELD, not max record

    I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following...

    Schlingel0015 pointsBadges:
  • SQL query help – SQL Server

    Okay, I hope I can explain my dilemma... I need a SQL select statement that will Select part_number from RCTOOL the column part_number has values such as BR643-0034-344-34 AS54-54689 A77360-3454-34456-4 B7374-343-33-32-356-433-11-1 In each of these cases ALL we want it to return is the values UP to...

    MyDanes35 pointsBadges:
  • Reasonable SQL query

    Do you this this is a reasonable SQL query to have in an application? sSQL = "select distinct "; sSQL += " S.ChainID,S.State,S.City,S.ChainCode,S.StoreNumber,"; sSQL += " DD.DeptID,D.DeptNum,DD.DeptDesc,DD.ReportGrpid ,' ' as tax1,' ' as tax2,' ' as tax3,DiscID "; sSQL += "...

    CarlCioffi345 pointsBadges:
  • Writing a SQL Query to get two random questions

    I want to write a SQL query to get two random questions: One from first set of questions and second from second set of questions.

    Bindi5 pointsBadges:
  • Writing a SQL Query

    Is it possible to write a query that goes through the entire database to search out a particular phrase to delete it, instead of going table by table? This is on a SQL 2005 Database that was injected. The following appears throughout the database tables: <script...

    Bosco32225 pointsBadges:
  • How to insert Hex values through SQL/400

    Hi, I'm creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can be possible to insert...

    color10 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 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