• OUTPUT query

    hi i have am osql script (.cmd file) with 80 line query in it , i run every 1 hours once. i shedule in o/s through task manager. i want the output in different xls every time ie: first xls for first hour second xls for second hour ........ till the last hours that is for hours thanxs

    D1972125 pointsBadges:
  • sql question on autogenerating customer numbers

    I want to create a table that automatically assigns a customer number to every email address that is entered into a table.

    Triciameza10 pointsBadges:
  • sql-programming the ‘in’ statement

    I'm working on a task ; the issue is: There are number of criteria for each category; the relation between the criteria's is OR and between the category is AND. The CSR can select number of criteria for each category (or not select anything); I supposed to get as an input all the selected criteria...

    ADBA5 pointsBadges:
  • HOW TO INCLUDE LOG IN INFORMATION IN AN SQL SCRIPT

    Please I have an SQL update statement which I want to put in an SQL script which users can run to update an oracle9i database running on a windows 2003 server.The statement is as follows: update jobs set JOBSTATE = 3 where APPID = 5 ; COMMIT; Exit I do not want users to be opening the script and be...

    IdongesitDaniel5 pointsBadges:
  • Comparing column values in different rows.

    sample table: A B C D E F G 1 d 3 t j 0 e 2 0 l o e p d 1 d 3 t k 0 f Ok, so in the table, column A should be unique. As you can, see row 1 and row 3 have the same value in column A. However, they differ in columns E and G. A quick aside, this is a metadata table, where column A is the key back to...

    Rcn3c5 pointsBadges:
  • How to use subselect in a case statement

    Getting error... "Token EXISTS was not valid...." on case statement... ,case when g.GFGSTS = '2' and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = '3' ) then count(*) end as Void#

    Qpgmr5 pointsBadges:
  • Trouble getting a count with union statements

    How do I get a count from unioned statements, then subtract some of the values from a sum of the others? For example, say I have a table called EMPLOYEE, and I want to see how many more male employees I have than female employees. Therefore, I want: COUNT(*) WHERE EMPLOYEE.GENDER = 'M' - COUNT(*)...

    JimmyIT1,725 pointsBadges:
  • DTS error after deleting xls file with script

    All, After I have deleted a xls file using an ActiveX script the DTS Package fails because the file is not there. I then have to go into the properties of the task and go to the destination tab and click the create button. The I have go to the Transformation tab and then run the package for it to...

    Gdckboyer20 pointsBadges:
  • How to update in SQL using DS

    My problem is that I’m basically doing an interactive update/create file (similar to DFU). The user is able to maintain a file in the screen, so how do I go about updating the ENTIRE File without having to manually update every record? I have a datastructure (cpRec) to put in the info from the...

    MMAGuy85 pointsBadges:
  • 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?

    Popers40 pointsBadges:
  • Cursor using update and order

    I'd like to declare a cursor to traverse a file in keyed order, updating some records It looks like I can do one or the other, but not both, that is I can set up the cursor with the order phrase or the update phrase buy not both. Is there a reason for this limitation? ec/exec sql c+ declare...

    Unknowingone195 pointsBadges:
  • Need help with running an external SQL query from within VB.Net code.

    Hi all, I'm in a bit of a bind and new to SQL. I have built a DB using the SQL Manager and it works perfectly in my code. I have used SQL Manager to build the SQL to rebuild my DB as I want to use it in my VB.Net code. When I execute this SQL in the SQL management studio it works 100 %. When I...

    Comtrendz5 pointsBadges:
  • 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 set record = :myds but...

    Unknowingone195 pointsBadges:
  • Database Admin…

    Will the real DBA please standup! Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did... nor did I. Well, I ended up doing security,...

    Znason460 pointsBadges:
  • 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...

    VentureFree45 pointsBadges:
  • 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....

    Yrrtni5 pointsBadges:
  • 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 Table A, create a...

    Ssp2y5 pointsBadges:
  • 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.

    IT10 pointsBadges:
  • 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...

    RMIS0 pointsBadges:
  • 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...

    Alexandria0 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