• SQL Query to consolidate rows into new table

    Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 ASK 99 C and put into...

    Baatch20 pointsBadges:
  • SQL Query to get the difference from average for every row with grouping

    Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with... I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to get a result set that looks like this using a single query...

    Baatch20 pointsBadges:
  • Oracle forms 10g in internet server

    How to run oracle 10g in internet server?  pls help me in details

    Intelprocessor1595 pointsBadges:
  • is data uploading on an HTTPS site as secure as using sFTP?

    is data uploading on an HTTPS site as secure as using sFTP?

    Topmac5 pointsBadges:
  • ASP Increased over night; how do I get it back to a normal level?

    we have noticed that our 570 box took a ASP hit from 62 % to 81% over a day.I am getting inputs from development staff what was happened ontheir side. Apart from that ,I want to investigate it from administration side what are the new objects saved during that period.but, i'm not sure how to do...

    qmaster1,675 pointsBadges:
  • Cannot show only one file extension

    After i used Anti Virus Software to kill virus in my computer.But i can not still show file extension ".exe". Note: other files can show all extension. but only file extension ".exe". How can i sovle it? please tell me. waiting to hear u soon.

    09778900185 pointsBadges:
  • steps for accessing sql data through ado.net code over LAN NETWORK

    steps for accesing sql data through ado.net code over LAN NETWORK

    Jib35 pointsBadges:
  • ASP.NET 3.5 control drag and drop

    How to drag and drop ASP.NET 3.5 control and move these control on form

    Amols10 pointsBadges:
  • How do I determine the Java_Home?

    I am trying to develop an installation package for a piece of java software that calls the %JAVA_HOME% environment variable in order to call the libraries. I guess my real question would be how do I create the environment variable based on the highest version of java installed on the PC. Currently...

    Ddominguez695 pointsBadges:
  • order by column number?

    Can you order by a column number, if so, what's the syntax?

    Shadowpuppet0 pointsBadges:
  • result shoud be like that pls *****sal**** in sql


    Madina2875 pointsBadges:


    AnandaDebnath280 pointsBadges:
  • Running Java 1.6

    How run java 1.6? it is possible without given any path in command prompt when my java file stored any folder but only one drive, this drives also give to in command prompt can we execute a that java  file?

    Varsha500950 pointsBadges:
  • % system ASP used:

    What are some ways to get this number down? Any suggestions would be great!!!

    Rmason345 pointsBadges:
  • Function PGM-QWASSTRSVR In JVAW using 95% of CPU, how to reduce it?

    We have a WAS Job using 95% of our CPU ( got it from wrkactjob) we tried to tunning garbage collection and appeared that worked cause it (after restart) the job went down and was working with 25% OF cpu.Suddenly it started to use amonge 95 to 99 % of CPU again, any solution to reduce that?

    Altino20 pointsBadges:
  • SQL or How to find out Oracle COLUMNS containing value

    SQL or How to find out Oracle COLUMNS containing value "0" in a table. Suppose we have 20 columns in a table lets say 'T1' having column like C1, C2, C3, ----- upto C20, and we have to know in how many column zero or any other user specific value is present. Lets say in C1, C5, C7 there is/are zero...

    Maheshmamu20 pointsBadges:
  • VB.NET Is it possible to drag a control from one panel of a splitcontainer control to the other?

    Hi, Can anyone tell me if it's possible to have a control (e.g. a picturebox) in one panel of the splitcontainer control, and then be able to drag the control in runtime to the other panel? Thanks in advance :)

    Darraca290 pointsBadges:
  • Visual Basic 6.0 Project Setup

    Hi.. i want to know how to create setup file of our project in vb6.0 wait i know how to create setup file using package and deployment tool but i want to know how can i create a file in which we can include ,MS Access database ,images, pictures, some animations i mean setup file with our own ideas...

    Hazimp5 pointsBadges:

    I used Linq to SQL method, but the problem is that at the last point where am suppose to add table, the instruction is that is should go to server explorer then open then table and drag items from server explorer to design surface, but i cant see any item to drag.Pls i need your suports,thanks

    Njubigbo5 pointsBadges:
  • Dummying a dataset with a concatenated list of datasets

    I have an input of 6 contactenated files and I wish to process with just the 4th file in the list. Will dummying the first 3 and last two still pull in the 4th dataset or by dummying the first in the list in effect dummy all of the inputs in the list? Does the dataset you wish to process need to be...

    Jaharvis15 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.

Thanks! We'll email you when relevant content is added and updated.