• 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:
  • Save and Read a text file from oracle database

    Hi, I want to save a text file into oracle database (i.e. relational table) and also read it from relational table. Can you please tell me the best approach to do this. Thanks

    DeepaBajaj10 pointsBadges:
  • Migration Problem

    I am migrating an Oracle 9i database to a new Oracle 9i database. My problem is that migration of two tables is taking very long. one takes 8 hours and the other takes 4 hours. The reason i can think of is that these two table have clob fields which are being migrated as varchar2 in the new schems....

    Newkipper0 pointsBadges:
  • Updating a table with sub query

    Hi, I need to update a table with a sub query. Here are the steps I'm following but I'm struggling to successfully update the table. the performance of this update has to be good because of the number of rows I'll be updating in production. any ideas? thanks in advance. drop table dummy_test create...

    Fitzdp0 pointsBadges:
  • Subquery as a table reference

    I use Showcase Strategy to develop queries and reports on the AS400. Showcase is telling me that I can't use a subquery to create a table reference to join with in the FROM clause. The Showcase Tech says subqueries are only allowed in WHERE clause. Non-AS400 SQL texts I have read suggest subquery...

    JohnDonnelly0 pointsBadges:
  • Using Local Variable as FILENAME in CREATE DATABASE Statement

    I am trying to use this statement in SQL Server 2000 :- CREATE DATABASE [Maintenance] ON (NAME = N'Maintenance', FILENAME = @TableName , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Maintenance_log', FILENAME = @LogFileName , SIZE = 1, FILEGROWTH = 10%) COLLATE Latin1_General_CI_AS GO The...

    TheHutt0 pointsBadges:
  • SQL behaves differently in two identical Oracle 10g db’s

    I have a SQL statement that is behaving differently in two "equal" databases (equal in schema, but size differs by about 50%). Here's the statement: select distinct 99, 31, b.school_id, a.provider_id, a.student_id, '2007', lpad('01',2,'0'), '0' from studprovider a, student b, school c where...

    Sprevost5 pointsBadges:
  • Use Dynamic Create Table Command in Stored procedure

    Does any one know how to pass a library and table name variable to the SQL CREATE TABLE Command? I need to be able to build the tables on the fly and the name needs to be different each time the table is created. I am calling the SQL Command from within a Stored Procedure. Thanks

    FCARPENTER200 pointsBadges:
  • media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • Call a stored procedure with output parameters

    Good Morning, I have created an oracle stored procedure which has 2 input parameters of type date and 1 output parameter of type PL/SQL table. I recieve errors when I try to execute the stored procedure in SQL*Plus. The stored procedure exists in a package and the Oracle database version is 10g. I...

    IYAN230 pointsBadges:
  • ASP .NET SQL Statement

    Thanks to SheldonLinker my earlier question has been answered. I continue to have 1 issuse and it is with my conditional SQL statement. I'm thinking someone will be able to correct this very easily. Here's the statement: If ("SELECT DataID FROM table1") = UserID Then Update Else Insert End If I...

    Wolfman240 pointsBadges:
  • Updating one record with a field of another record where two other fields match

    I have the following Table: XREF Group Projid id1 id2 ----- -------- ----- ----------- AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG...

    Donnewbee0 pointsBadges:
  • SQL – IF Exists Update Else Insert

    I have searched far and wide but have not been able to solve this problem. I am still in the early learning stage and this is the most complex issue I've come across so far. I have a form that when submitted needs to either update fields in a table or insert new records. I originally created a form...

    Wolfman240 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