• How to count the common column rows in the table for each column and row…..

    I have a table and that table have columns like d1,d2,d3,d4....... d1      d2    d3    d4 --------------------------- 200   300   100  300 100   200   101  101 300   ---    300  200 how can i display the output like below...  for each row.... ColumnD1 Count 200    3...

    Paanduranga15 pointsBadges:
  • Operating DOS through excel(VB or macro).

    Cheers. I m new to IT.I wish 2 operate DOS through excel. For example , in DOS we write some command and then press enter, then dos displays the information concerned with that command. Is this possible to do this, i.e writing command in DOS and pressing enter jst by writing a programme in...

    Begginer65 pointsBadges:
  • web-based GPS tracking application development with asp.net

    i'm a final year degree student majoring in network computing.  i'm developing a GPS related web application where data is being taken from a gps tracker (TK-102), which can send data to a ip address and port number defined. there for i need to save this data to a database and then represent it on...

    Veriya30 pointsBadges:
  • Trying to Design a Split Database Access 2007/SQL Server Express

    Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I've been researching this for awhile, and going...

    Dataempress115 pointsBadges:
  • Using AS400 COBOL or CL Program to Call an Excel File and Pass Parameters Back and Forth from 400 to Excel Back to 400

    [html xmlns=""> I am beginning my investigation to figure out how to use either a 400/COBOL program or a CL program to call an excel spreadsheet that requires three parameters to a calculation and to return a value back to my 400/COBOL program of CL program so that I then can use that value in my...

    400Programmer185 pointsBadges:
  • Embedded SQL in RPGLE

    I am trying to get some counts and totals from one file and put them in another. My SQL statement works fine with STRSQL, not in the RPGLE. Do I have to declare/set a cursor, exec sql and close the cursor just to put the total in another file? C/EXEC SQL C+ INSERT INTO outputfile C+ SELECT...

    Nickhutcheson165 pointsBadges:
  • Difference between QM Query and traditional query

    When both a QM Query and a traditional Query are run against a database file with IDENTICAL record selection, the traditional query returns more records. I can only guess that it has to do with a difference in the way each utility handles uncommitted data. It almost looks as if traditional Query...

    slateken230 pointsBadges:
  • QTP Script for Data Driven Testing using Notepad

    Set f=createobject("scripting.filesystemobject") Set f1=f.createtextfile("d://file1.txt") f1.writeline"Raju Rani" f1.writeline"King Queen" f1.writeline"Radha Krishna" f1.writeline"Thirupathi Gangula" f1.writeline"Bala Kishan" The above script creates a notepad in "d" drive with name file1 Raju Rani...

    375 pointsBadges:
  • Debugging Oracle Form in 10g

          Hi , I am currently working in form 10g and i m newbie to that technology...        I want to debug my form and also check step step by values of variables which i defined.. Can u plese help me out to solve my problem...if any document available to step by step debugging... Thanks

    Nkswapnil30 pointsBadges:
  • Add third or fourth monitor to my Window XP SP3 setup

    We want to add a third monitor and possibly a fourth to our system. The computer is XP SP3 and our video card has two ports: DVI and VGA. How can we add two or three more DVI connections?

    Karl Gechlik9,860 pointsBadges:
  • Access 2003 – command button to show query in pivot format

    I have a form with a comman button.  I want the user to be brought to a query when they press the button.  The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead.  What am I doing wrong?

    Smbecker5 pointsBadges:
  • Serving web pages from the ILE

    In ILE Cobol I can create and XML document using the built in XML generate (and XML parse) statements. How do I go from there to serve this to a browser? I would like to use a web page IDE tool that I hope can output XSL and then merge the XML and XSL to give HTML to be served to the browser. I am...

    JohnDavids35 pointsBadges:
  • Crystal Reports XI – Duplicate input parameters

    I am creating a Report with the input parameter for all the sales representatives across multiple states. On the report input parameter the values listed are as follows: N/A User1 - CA User2 - CA User3 - CA N/A User1 - CO User2 - CO User3 - CO and so on. I am hard coding N/A as the default value...

    NaviIT5 pointsBadges:
  • Making Joomla public. Concerns and options.

    We have an internal Joomla website. We want to make it public to the Internet. What security precautions need to be taken? What do we need to make it public? We are running this on IIS off of a Win 2003 Server.

    Karl Gechlik9,860 pointsBadges:
  • Creating a test set in a solution manager

    How do I create a test set in SOlution Manager? Also is there any way i can copy test plans & packages from other Test sets and add them to my new test set.

    Jouwad5 pointsBadges:
  • How do we create a repository for checking files into and out of it?

    We want to set up a repository to check files into and out of. What is the easiest cheapest way to make this work? Server 2003 standard.

    Karl Gechlik9,860 pointsBadges:
  • How can we make a site respond to www. and just http?

    We have a website running on IIS on a Windows 2003 web server. The site currently only works if you type in www.websitename.com how can we also make websitename.com direct to the website? Our DNS is hosted by our ISP but we have a control panel to make changes.

    Karl Gechlik9,860 pointsBadges:
  • Without Using Script in SSIS

    HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script... please help me T_T.... Thx so much... :D

    SSISCaseStudy5 pointsBadges:
  • Production SQL Database has been restored with Old database backup

    Dear Expert, I need your Advice, today in morning i run Symantec backup restore on SQL 2008 server where i overwrite the production Database with Old backup. Is there any way i can retreive the old Database until yesterday. i dnt have any backup of New database which i accidentally overwritten.  ...

    Aleem60015 pointsBadges:
  • SQL Server I/O

    Hello, we have a database that contains three tables. Each table has more than 25,000,000 rows in them. All three tables are in the same file group, array, and drive. Our daily Avg physical I/O is 1,000,000. Our users are complaining that the system is slow daily. Everytime a user writes to any of...

    Rick Martinez585 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