SQL update question
I’m new to SQl and cannot figure out how to do an update without listing every field in the record, sorry, row. The file I’m updating has about 50 fields, any of which might be changed. They are in an external ds that maps the record format, so it would be nice to say update [...]

Answer Question   |  December 20, 2007  11:36 PM
AS/400, RPG, RPGILE, RPGLE, SQL

SQL query – Unique item with latest date of entry
Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three date entries [...]

Answer Question   |  April 18, 2013  6:44 PM
Aggregate function, Distinct, MAX, Microsoft Access, Query, SQL, Subquery

Changing Table with RUNSQLSTM
I have a table that I need to increase in size. It was created using QDDLSRC and the RUNSQLSTM command. This table has a DDM file connected to it. Is the a CHANGE TABLE or REPLACE TABLE statement that I could replace the CREATE TABLE statement with so I can rerun the RUNSQLSTM and leave [...]

Answer Question   |  August 12, 2009  5:54 PM
DDM, QDDSSRC, RUNSQLSTM, SQL

MSSQL Stored Procedures
So im in my first year as a programming student and im stumped on a database i need to go alongside its stored procedures. Sorry beforehand if my english isnt that great,its not my native language.Anyways the database(tables) goes like this: Customers(CID,Name,LastName,Telephone) CID being the key. Plans(PID,CID,Descryption)CID being the key. DebitMovements(DMID,PID,Date,Amount)DMID and PID being keys. [...]

Answer Question   |  December 11, 2007  10:50 AM
SQL, SQL Server, Stored Procedures

Block Of Activity
I have timestamps for events stored as datetime’s. Given a starting datetime, is there a way to find the block of timestamps where: 1. At least one timestamp is within 1 hour of the given datetime. 2. No individual timestamp is greater than 1 hour after the previous timestamp (or possibly before the next timestamp [...]

Answer Question   |  December 11, 2007  7:45 AM
SQL, SQL Timestamp

SQL and CL
I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?

Answer Question   |  December 25, 2007  5:33 PM
CL, RPGLE, SQL

SQL Comparing Transaction Data Times
Hello: I have 2 tables: Table A (unique table of IDs and final times) ID – MaxTime 100 – 11/30/2007 200 – 11/15/2007 300 – 12/1/2007 Table B (transaction data for each ID) ID – Time 100 – 11/30/2007 100 – 11/29/2007 100 – 11/28/2007 200 – 11/18/2007 300 – 11/31/2007 For each ID in [...]

Answer Question   |  December 3, 2007  11:44 PM
SQL

SQL to find minimum finish date
Hi , I have table which contains project ID,task id and the finish date I need to get the minimum finish date for a each project id if a project id has multiple matches of finish date then i need to take the minimim fnish date of the minimum tak for that project id. E.g [...]

Answer Question   |  December 1, 2007  5:05 PM
SQL

Report Properties Code
Where can I find information on how to use the Report Properties Code

Answer Question   |  November 27, 2007  3:30 PM
Reporting Services, SQL

Oracle Cross Schema View
I am creating a cross schema view and am receiving the error ‘Table or View does not exist’ on the second table of one schema in my view. Here is the View: CREATE OR REPLACE VIEW WORKMGMT.VIEW_WORKMGMT_USERS( USER_ID, USER_VALID_FROM, USER_VALID_TO, DEFAULT_UNIT, LANGUAGE_PREFERENCE) AS SELECT SU.ORGANIZATION_USER_ID “USER_ID”, TO_TIMESTAMP(TO_CHAR(SU.EFFECTIVE_FROM,’YYYY_MON_DD’),’YYYY-MON-DD HH24:MI:SS’) “USER_VALID_FROM”, TO_TIMESTAMP(TO_CHAR(SU.EFFECTIVE_TO, ‘YYYY_MON_DD’), ‘YYYY-MON-DD HH24:MI:SS’) “USER_VALID_TO”, WM.DEFAULT_UNIT_ID [...]

Answer Question   |  November 20, 2007  9:08 PM
cross schema, Oracle, Oracle error messages, Oracle Views, SQL

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 researching this problem with [...]

Answer Question   |  February 24, 2010  5:30 PM
RPGLE, SQL

Developer
Hi! I am currently developing a Document Tracking Database System using MS Access. I only have limited skills on access bt I’m willing to take an advice. Can you advise me on how to scan and save documents using MS Access database? Regards, Dee.

Answer Question   |  December 3, 2007  10:24 AM
DataManagement, SQL

MS SQL 2000 memory leak
Hi We are running Adobe Workflow server which is based on SQL 2000. Both appliaction and SQL 2000 rside on the same server WIndows 2003. Lately we faced the problem of Time Out from Adobe and it seems to be that SQL is consuming allot of memeory. When checked Tak Manager we found out that [...]

Answer Question   |  December 2, 2007  12:52 PM
Memory leak, SQL, SQL Server 2000

Help!
I am new in the staffing industry and trying to learn a thing or two in IT as we staff lots of IT postions. Can anyone give me a few quick basics that will at least help me talk to an IT person looking for a job? I know I need to learn about languages [...]

Answer Question   |  November 13, 2007  5:28 PM
C, Careers and staffing, Dreamweaver, SQL

USE DATABASE
How can I write a stored procedure which can switch to new databases using something like “use DBASENAME”, but without knowing the dbase names before the procedure runs? The example below was my attempt to do this using SP_EXECUTESQL. The reason for this is so that I can call stored procedures within my stored procedure [...]

Answer Question   |  December 2, 2007  1:40 PM
Database, SQL, Stored Procedures, USE DATABASE

SQL 2005 Restore DB with Multiple files in Primary File group
Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee

Answer Question   |  December 2, 2007  8:58 PM
Database, Restore, SQL, SQL Server, SQL Server 2005

combine and sum fields in sql
I have a file with approx. 20 columns: 4 of the columns are numeric: finchg1, finchg2, finchg3, finchg4 – one of the columns is acct number. each acct has only one row. I need to combine the four fields into one – can I use the sum function to do this – how? Thank you

Answer Question   |  October 29, 2007  3:47 PM
SQL

Lotus notes to Sql
I have text files as attachments to emails in Notes Database and I would like to get the information from the attachment and store it in Sql database. Could any one suggest the best possible way to accomplish this I have set of data in the text file It goes like this // Name: Tom [...]

Answer Question   |  October 26, 2007  10:14 AM
Lotus Notes, SQL

Accountant
What software proficiency, would enhance my career. There are so many MS Certificates.

Answer Question   |  October 26, 2007  3:00 PM
Application development, SQL, VBA

Systems problem
I always wonder why this happened to my system…..a situation like this. I redesign my system since its predecessors made me a lot of headache. The previous months after it was been upgraded many complains in one particular problem. This is what the problem is……they notice that in no particular time there are data that [...]

Answer Question   |  December 2, 2007  3:11 AM
SQL, SQL Server, VB