• Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • Convert time as text to datetime

    I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You...

    VentureFree45 pointsBadges:
  • Damaged software

    If a company's software product credibility has been damaged, do you think they can salvage it?

    Tsmith740 pointsBadges:
  • Create a menu-driven program that allows users to select one of five international currency types, input the amount of a foreign currency, and then co

    Consolidate all the sections of the Currency Conversion development documentation: requirements, design, and testing.

    Tsmith740 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE357,100 pointsBadges:
  • i want to change the true bits to false and vice versa

    i have a table where i have true and false bits..i need to replace the true bits to false and vise versa

    Sam535 pointsBadges:
  • SQL and Moss 2007 from Jameel Ur Rahman (Abbottabad)

    hi, I recently done Moss 2007 certification . an di want to know the relation of SQL and Moss 2007 , and also let me know for Moss 2007 implemention how i prepaer my self regarding SQL because SQ L new for me any book or white paper that help me and also SQL 2005 Administration thanks jameel

    Jameelrk5 pointsBadges:
  • run vbscript on remote computer from java

    How do I run vbscript on remote computer from java application?

    Ilana10 pointsBadges:
  • i’m having one web application ,actually now in that when user submits the data it is storing directly in database instead of that now i want to shows

    Now in that when user submits the data it is storing directly in database instead of that now i want to showsuser that he can edit the data in preview page & if now the user is corrected the data then he wants its to store in database. pls help how to do the logic or code. using java servlets,jsp...

    Kishore2k715 pointsBadges:
  • How to install a passive node on an active/active SQL Server cluster

    We have a SQL cluster server running with SQL Server 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So once I’m done, the cluster will be a Active/Active/Passive cluster. Because...

    SQL Server Ask the Experts2,585 pointsBadges:
  • MS Access ActiveX Control

    I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that? Thanks, Asuasol

    Asuasol10 pointsBadges:
  • “GET DIAGNOSTICS” SQL Procedure

    I am currently writing an SQLCBLLE Program on a V5R2 box. I would like to use the SQL Procedure "GET DIAGNOSTICS", however each time I enter it into my code the both SEU and the compiler complain about it. I receive the message GET was not expected. I know the procedure was supported in V5R2 but...

    FCARPENTER200 pointsBadges:
  • Internet Explorer

    Hi, I am using Xp With SP2 as meber of active dir ina organization.Suddenly i used to get a error message some thing related to"Runtime error C:/programfiles/InternetExplorer/ie need to terminate unusal way" .I am using IE7 at that time i removed it afterwards and tried with IE 6 but the error...

    IT Admin40 pointsBadges:
  • Oracle Query: Return a date eg 29 February 2008

    Hi How can I return the last day of the second month of the current year in Oracle Thanks in advance

    Csshahie5 pointsBadges:
  • Combined Address

    I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is...

    Thuzinec10 pointsBadges:
  • Net Present Value

    In an Access Form, I want to be able to have five values in text boxes and use those five values along with another value in the form, the return rate, to produce the Net Present Value

    Mattylar125 pointsBadges:
  • Open Import window via code in MS Access

    Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.

    Rjwilcox45 pointsBadges:
  • accessing pdf file data in lotus notes form

    I have a pdf form in which i am allowed to enter the data. I want to know that how we can access ths data from a pdf file in the lotus notes form or same in views?

    Saket5 pointsBadges:
  • Which .Net Framework and or service pack should I keep installed on my XP home Edition Computer?

    I recently tried installing a new software which kept giving me a "failed to initialize properly (0xc000142) click on ok to terminate the application" error. I need this software, it is specialty for my specialty. I read the manufacturer notes that I must have .net framework 2.0 to run it. So I...

    Joshuasquestion5 pointsBadges:
  • How to make career in SAP Netweaver

    I am a fresher trained in SAP-ABAP and I was strong in JAVA,J2EE. What more should I learn to make a move to SAP Netweaver. What is your suggetion? (Whether to move to NETWEAVER or to continue with ABAP) Which of them do you think is in demand? Thanks in advance.

    Sireesha.garlapati5 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