• Learning SQL Part 2

    Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?

    CompEng1,240 pointsBadges:
  • About PIC programming

    Which development tool is best for a beginner in PIC programming?

    Doublengineer5 pointsBadges:
  • How to subtract positive number from negative number in an IF string

    Having trouble with knowing how to subtract positive from negative numbers in an IF formula. Also want to add a conditional formatting for all negative time in column H.

    WAT5 pointsBadges:
  • SQL: comparing rows and give the change

    saving greetings to everyone! i m receiving a dump data at day 1, inserting all that data into a database. this database has about 30 above tables, each and every table has about 100 above rows. every table has a column name cell id. on 2nd day i again receive the dump which also has to be inserted...

    K3820 pointsBadges:
  • Delete OLD files from Table not having date or timestamp

    Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

    RJES45 pointsBadges:
  • Dlls to access Notes and Domino Server Database.

    Hi, I need to create an application using C# such that i can access all the user's mailboxes existing on Server. So kindly provide me the API which will allow me to access each mailbox( nsf files) of each user stored on the Domino Server. Basically i am looking for an API by which i can just...

    Preeti08185 pointsBadges:
  • Determining if an interface problem exists

    We have built a website for a client (a bank) in HTML (Dreamweaver, Flash, etc.), and converted it to operate off of a “WebDNA” database programming language, instead of PHP or ASP. We are now told by the client's ISP that there are major concerns about compatibility and security relating to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • iSeries performance question

    Hello everybody, I'm trying to figure out the best way to count the number of records matching specified criteria in large PF. (The file has over 50 million records currently and with some purging we hope to bring it down to around 20 mil.) Anyway, I created the (SQL) view: create view largePF99 (...

    Dushan0 pointsBadges:
  • Inner join Solution

    i write the following Query to execute against the 1500000 in SQL Server 2000 DECLARE Cur_Prefix CURSOR FOR SELECT PrefixNo,PrefixLen,AfterPrefixLen FROM NoSeriesMaster_Prefix WHERE PrefixType='SMS' order by ID OPEN Cur_Prefix FETCH NEXT FROM Cur_Prefix INTO @PrefixNo,@PrefixLen,@AfterPrefixLen...

    Mxaxyogesh200230 pointsBadges:
  • Pocket PC: How to stop a form from closing

    Using C#, on a WinForm, to stop a form from closing, I simply have to put this line in the public Form1(): this.Closing += new System.ComponentModel.CancelEventHandler(this.Form1_Closing); and add this bit: public void Form1_Closing(object sender, System.ComponentModel.CancelEventArgs e) { if...

    TJay85 pointsBadges:
  • VB 6, SQL Server 2000 & Crystal Reports

    i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.

    RAYNISH35 pointsBadges:
  • Learning SQL

    I work in a large company in the automotive industry. We use the AS400 system corporately. I am just learning the query system. I have used a little of the iSeries and found that to be somewhat burdensome. My co-worker introduced me to the SQL language. What I am trying to do is using MS Access and...

    CompEng1,240 pointsBadges:
  • Data migration tool

    how can we provide the security while migrating the data?

    Sureshboddu10 pointsBadges:
  • Can a command button macro run a make-table query with an auto-inputted parameter value?

    I want to run a make-table query with a parameter, using a command button click event on a form showing a single record. The parameter value needs to be inputted automatically using the value of a control in the current record of the same form. Can this be done with a macro event? If so, what does...

    Shdrc5 pointsBadges:
  • VB 6 EE

    when using mshflexgrid how many rows of datas can i listed... while instering values when the no of rows is more than 500 its hanging. can u please give me a reply ?

    RAYNISH35 pointsBadges:
  • textbox autocomplete item limit vb .net

    Hi how can I have around 25000 items in a textbox's autocomplete collection... also can I restrict the entry on the textbox to the collection only.

    Anshukk5 pointsBadges:
  • Creat program on VB

    Create a program using VB to calculate tax on a monthly and yearly basis of any individual based on the MRA report. The program should also calculate the different penalties for late submissions of annual return of income and late payment of tax (including interest for late payment of tax Can any...

    0 pointsBadges:
  • Javascript prompt

    I've written a prompt in code, not coming up when page is opened. Why?

    Libs5 pointsBadges:
  • using vb6 on XP

    im currently using vb5 on a 98 machine and a xp machine. the xp computer allows me to do vb development but not use the setup wizard in which i must still use my 98 computer. if i purchase vb6 will the xp computer allow the setupwizard to work. thankyou dlhake

    Dlhake5 pointsBadges:
  • Deadlock issue in SQL Server 2005

    I have encountered a deadlock issue in <A href="http://searchsqlserver.techtarget.com/topics/0,295493,sid87_tax301323,00.html”>SQL Server 2005</a>. According to the trace flag 1204 report, the following two queries are causing the deadlock: 1. Simple insert statement INSERT INTO...

    SQL Server Ask the Experts2,585 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