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

    Jdcruz10 pointsBadges:
  • 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

    Leeland0 pointsBadges:
  • 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 PROJ ID Task ID FINISH DATE...

    Ybax naveen5 pointsBadges:
  • Report Properties Code

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

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

    Ora mer20 pointsBadges:
  • 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 and softwares at the very least. Can anyone...

    Nikki0 pointsBadges:
  • 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

    Pongmeister0 pointsBadges:
  • Accountant

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

    05120 pointsBadges:
  • 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 // Age:22 //...

    Nanacy0 pointsBadges:
  • programming using c#,winforms and visual studio.

    i cant think of what to write in this part of the code so that the password character is " * " when the user enters his/her password.pliz help private void txtPassword_TextChanged(object sender, EventArgs e) { char Password =GetStyle ("*"); txtPassword.Focus(); } i just have no idea what...

    Drsingh0 pointsBadges:
  • Delete all data in the database

    Good day! Currently I am using MS SQL Server 2000. I wish to delete all data in the database table except data in login table and security table. Furthermore, TRUNCATE is done on stand-alone and child tables, else DELETE if table has any foreign key references (normally refer to parent tables): Is...

    Hunkgym5 pointsBadges:
  • Where is the best site to learn SQL?

    Where is the best site(s) to learn SQL? A place with example coding etc...

    JHAMLW5 pointsBadges:
  • sql

    display the third and seventh employee salary details

    Rekha0 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