Search Result

Collapse
11 results in 0.0041 seconds.
Keywords
Members
Tags
order
  •  
  • bbaaking
    started a topic complicated SQL:how to using a query to compute rank of order(Outstanding of Class 1)
    in MySQL

    complicated SQL:how to using a query to compute rank of order(Outstanding of Class 1)

    Hi,

    I have be in trouble for 2 weeks, hope some nice people can help me.

    Background:Ther e are some technical service data (ServiceID, TCID, EndTime, and QoS) submitted by client in a whole year about technical support, and there are a unique primary key (ID by name) because there are some duplicates. I must use one single query statement(not insert/delete/update, and not stored procedure) to process a computation,...
    See more | Go to post
    • Rettla
      started a topic Stored procedure to cancel an order
      in SQL Server

      Stored procedure to cancel an order

      Hi guys,

      I am working on a project that simulates an online shares and securities trading environment. Participants can place buy/sell orders and cancel them. If an order is placed before the market closes at 1700, it should only be cancelled before 1700. It however seems that there is a loophole and participants are cancelling orders that would have already been processed.I have attached a copy of the stored procedure that I had tried...
      See more | Go to post
      Last edited by Rettla; Mar 9 '12, 05:39 PM. Reason: I was including the code in the question
      • AdilSaumtally
        started a topic Reorder Stock code
        in Visual Basic

        Reorder Stock code

        I am currently trying to figure out a code to order in more stock (reorder amount) when stock reaches its 'reorder level' but do not know where to start.
        If this has made you confused please look at the picture below.
        Also, is there a more sofisticated code to use rather than just IF?...
        See more | Go to post
        • Knight Rider
          started a topic trouble with css on spry top navigation menu
          in HTML CSS

          trouble with css on spry top navigation menu

          I am having some trouble with this site. I'm trying to have the top navigation bar extend all the way across the page (the medium brown color) rather than only going the length of the top nav items, and I want it to show up with About Us first, and Media last aligned to the right (in different browsers it shows different orders and alignment). Also, I would like there to be no extra white space below the top nav banner before the picture.
          ...
          See more | Go to post
          • Niheel
            started a topic Looking for ways to improve our drop down menu
            in HTML CSS

            Looking for ways to improve our drop down menu

            This question is in reference to the drop down menu on Bytes.

            I don't like the fact that our menu isn't ordered alphabetically in top down approach.

            One of the reasons we had to go with the current approach is to make sure that the drop down box doesn't exceed the vertical window size on most computers, pcs, tablets, phones.

            I'd like any suggestions you might have on how to improve our menu. How would...
            See more | Go to post
            • Rebecca McCallan
              started a topic Export details coming up in random order
              in Access

              Export details coming up in random order

              I have exported some data from Access to Excel (2010) and once exported to access the data is in a different order from when it was in the query. The data is all under the correct headers but each column is randomly ordered. The query is in the following order (by fieldnames) CompanyName, CompanyAddress, TownCity, Postcode, ContactNumber1, WebsiteAddress, VATNumber, CompanyContact and CompanyType. The export comes out in this order (by header names)...
              See more | Go to post
              • Noam Noam
                started a topic How to play sounds in a certain order?
                in C Sharp

                How to play sounds in a certain order?

                I am creating a piano program with an record in it.
                I am in order of the play button to play the sounds that the user recorded, I need to create a method that plays the recorded sounds in the order that the user played them.
                So my question in basicly, how do I play sounds in a certain order (one sound plays, ends, and then the next one starts)?
                thanx!
                See more | Go to post
                • GottZ
                  started a topic two unusual tables, one query
                  in MySQL

                  two unusual tables, one query

                  hello there,

                  i'm a SQL newbie and could need some advice.

                  i'll show you now some abstracted tables and an explaining of what i'm going to do with them.
                  i truly hope its not that ugly written as i think.
                  besides this is the first time i ever ask for SQL help.
                  so please don't go at me like i've never read a documentation.

                  i'm having theese two tables:
                  Code:
                  +----------------+
|      USER
                  ...
                  See more | Go to post
                  • oshany
                    started a topic How to force scripts include order
                    in Javascript

                    How to force scripts include order

                    HI,
                    I have a very annoying problem - I have 2 external js file - script1.js and script2.js.
                    script2.js depends on script1.js being executed 1st. So, in the relevant jsp I have:
                    <html>
                    ...
                    <script src="script1.js "></script>
                    <script src="script2.js "></script>
                    ....
                    </html>

                    Usually it works fine.
                    However, from time to...
                    See more | Go to post
                    • chemlight
                      started a topic Order array based on number of duplicates
                      in PHP

                      Order array based on number of duplicates

                      I'm trying to figure out how to order an array based on the number of duplicates, and then remove all duplicates.

                      This is my code right now:

                      Code:
                      foreach($acID as $searchterms){
$results = mysql_query(SELECT * FROM table
     WHERE field LIKE '%$searchterms%')

   while($row = mysql_fetch_array($results)){
         array_push($resultArray, $row['id']);
         }
}
                      ...
                      See more | Go to post
                      Last edited by Markus; Jan 28 '09, 09:53 PM. Reason: added [code] tags.
                      • jmarcrum
                        started a topic MS Access Skip the first character in a field and then sort
                        in Access

                        MS Access Skip the first character in a field and then sort

                        Hey everyone!

                        I'm working in Access 2003 and need help with the 'order by' in a query. I have an CrewCode that includes a letter as well as numbers, and I want to sort by the numbers. The CrewCodes are for instance:

                        D5159
                        D1801
                        D337
                        D5276

                        When I just sort by ascending, it's all out of order. How would I do this?

                        THANKS SO MUCH!!!
                        See more | Go to post
                        Previous template Next
                        Working...