• using group by by joining 2 tables SQL

    there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

    Lak5 pointsBadges:
  • SQL find duplicates SQL Server 2008

    Up against a SQL question that is difficult to code.  Any help is greatly appreciated.

    Jtigges5 pointsBadges:
  • How to Export a MS SQL Image column to a file.

    I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?

    KatanaBeach115 pointsBadges:
  • display file driven by cl

    Is there a sample CL/SQL code on how to display a message on the screen based on the last record data in a table. there is a stat feild in my table for eg if stat is 1 then display test1 if stst is 2 then display test2

    Mannar5 pointsBadges:
  • Systems Management Server console2003 remote tool

    I'm running SMS 2003 SP3, now I reinstall my PC as Windows 7, after setup SMS administrator console on Windows 7, I found the remote tool can not connect to XP OS SMS client, for Vista/Windows7 SMS client, there are even no selection of remote tool from the console. Remote assistance is ok to...

    Jacmar20 pointsBadges:
  • Problems with SQL Server 2000

    In my office we work on SQL Server 2000, and we have software in .NET Question 1: Sometimes the message display reads “You cannot access because of user limit". What does this mean? Question 2: Some of my computers work slow in SQL for an hour or two at a time. What can I do to fix this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Adding files to TempDB

    Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Assign default values to SQL VIEW columns

    I'm trying to assign default values to VIEW columns defined for left joined columns or columns created by aggregate functions. I've tried the ALTER TABLE after the VIEW was created but get an error that my VIEW is not a TABLE and the ALTER VIEW is not supported by DB2/400 v5r3.

    Tgee60 pointsBadges:
  • How should I make the SQL in iBatis having Parameter of ListMap?

    How should I make the SQL in iBatis having Parameter of List<Map>? When I search primery key at a table having two primery key, I have plural parameters as a parameter. This parameter is List<Map>. It is an example of Parameter as follows EX) 1. parameter List<Map> paramList = new...

    Jhyukchoi5 pointsBadges:
  • SQL index on dds file

    Will and existing rpg program that is doing a file read/table scan utilize an sql index with changing any of the rpg program?

    Finch25 pointsBadges:
  • retrieving run time records in SQL

    how to retrieve multiple rows at run time in sql

    Sasthri5 pointsBadges:
  • RPGLE/SQL PROBLEM

    I am trying to join our sales analysis file, all fields, with our accounts receivable file using SQL. I can extract the information okay but when I issue the following fetch command: FETCH NEXT FROM SALESSORT INTO :SALESREC ,:CUSTREC it skips the null records. I have spent the last 6 hours...

    Burtmis100 pointsBadges:
  • Using SQL and Postgre on the same machine

    We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL server STD 05 between Sites

    besides buying Enterprise($$$$$.$$), how else can I keep these servers (sych'd, mirrored, ???) via a network link between cities? Server1(win-sql-05)DB <> Server2(win-sql-05)DB

    Multilanguage25 pointsBadges:
  • Auditing users of STRSQL

    I want to audit the SQL statements of users who use STRSQL. I know if you press F13, you can change the interactive SQL Session Services. If you choose option 4 it will save all SQL statements into a file. But I was wondering if it is possible if we setup this as default when starting up STRSQL? So...

    AS400 - Ask the Expert485 pointsBadges:
  • SQL Access Query

    I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word "Udate"     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL,...

    CompEng1,185 pointsBadges:
  • Multiple databases on a server – SQL

    My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards

    Rajg5 pointsBadges:
  • Querying multiple member PF with SQL

    I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

    Rajgoaj280 pointsBadges:
  • File overrides within interactive SQL sessions – how are they applied?

    I have an issue where, in an interactive SQL on an iSeries (V5r4) despite specifying the library and file name for a delete statement, the action deletes from a file listed in the overrides. Is there a way to prevent this from happening?

    Nephilim5 pointsBadges:
  • SQL for MS Access Syntex issue

    I have started to read the book by Cecelia L. Allison and Neal A Berkowitz on SQL for Microsoft Access.  and there is a syntex listed below that has been giving me a problem.   I get an error with the word UNIQUE.  So I removed it from the statement and then I get an error with the ON section...

    CompEng1,185 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