Search Results

Search found 28469 results on 1139 pages for 'select statement'.

Page 84/1139 | < Previous Page | 80 81 82 83 84 85 86 87 88 89 90 91  | Next Page >

• select top 50 records from sql

  - by air

  i have following database table name tbl_rec recno uid uname points ============================ 1 a abc 10 2 b bac 8 3 c cvb 12 4 d aty 13 5 f cyu 9 …

  Read the article

• DATEFROMPARTS

  - by jamiet

  I recently overheard a remark by Greg Low in which he said something akin to "the most interesting parts of a new SQL Server release are the myriad of small things that are in there that make a developer's life easier" (I'm paraphrasing because I can't remember the actual quote but it was something like that). The new…

  Read the article

• script to recursively check for and select dependencies

  - by rp.sullivan

  I have written a script that does this but it is one of my first scripts ever so i am sure there is a better way:) Let me know how you would go about doing this. I'm looking for a simple yet efficient way to do this. Here is some important background info: ( It might be a little confusing but hopefully by the end it will make…

  Read the article

• What Issue Tracking System to select?

  - by Mikee

  What Issue Tracking Sytem is the most appropriate for fast, big, multilingual and international websites? The system has to handle both technical and content/editorial issues. What's the size and type of your site do you run? Whart System are you using for the keeping it state of the art? Thanks a lot for sharing your good…

  Read the article

• Making TMUX use Alt+Num to select window

  - by Oxinabox

  I have been messing with TMUX, and I am liking the configuration abilities. The window list at the bottom makes me think that the same shortcut for changing windows in Irssi, should work in TMUX, but it doesn't. So at the moment, I have to press C-b then a number to get that window open. I am happy having C-b for my normal…

  Read the article

• Automatically select last row in a set in Excel

  - by Luke

  In Excel 2003, I am trying to keep track of some petty cash, and have it set up with the denomination along the top row, along with a sub total and difference column. I want a small section that shows how many rolls of coins I should have, by taking the total amount, and dividing it by however many should be in a roll, and…

  Read the article

• Windows 8.1 Search does not automatically select first search match

  - by Miguel Sevilla

  When I search in Windows 8/8.1 (start menu-start typing), it doesn't automatically highlight the search term. For example, if I'm trying to open the "Internet Options" panel and type the entire thing out in search, I have to down arrow or tab to the "Internet Options" search result. This is retarded. I'm used to Windows…

  Read the article

• PC doesn't select right monitor sometimes

  - by Madhur Ahuja

  I have an ACER LCD monitor with Intel G33/G31 display chipset. The preferred resolution for monitor is 1440x900. The drivers for both monitor and display are correctly installed and displayed in Device Manager section. However, I have observed, sometimes, in Display properties, my PC shows Display Device on: VGA instead…

  Read the article

• How to select a server that supports Windows scheduled file IO

  - by Kristof Verbiest

  Background: I am developing an application that needs to read data from disk with a fairly consistent throughput. It is important that this throughput is not influenced by other actions that happen on the disk (e.g. by other processes). For this purpose, I was hoping to use the 'Scheduled File I/O' feature in Windows…

  Read the article

• .htaccess to restrict access to only select files

  - by Bryan Ward

  I have a directory in my webserver for which I would like to serve up only pdf files. I found I can restrict access using the .htaccess, and using something like <FilesMatch "\.(text,doc)"> Order allow,deny Deny from all Satisfy All </FilesMatch> to serve up everything except a regular…

  Read the article

• NetworkManager will not allow me to select WPA

  - by Mala

  Hi I have a fresh install of Crunchbang (basically Ubuntu with Openbox instead of Gnome). In any case, I can't connect to my WPA network - when I click on it in the nm-applet and it asks me to authenticate my only options are: WEP 10/128-bit key WEP 128-bit Passphrase LEAP Dynamic WEP (802.1x) …

  Read the article

• Select different parts of an line

  - by Ricardo Sa

  I'm new to regexes and have a file that looks like this one: |60|493,93|1,6500| |60|95,72|1,6500| |60|43,88|1,6500| |60|972,46|1,6500| I used the regex (\|60|.*)(1,65) and I was able to find all the lines that have the information that I wanted to changed. How can I make an replace that when…

  Read the article

• Log shipping on select tables.

  - by Scott Chamberlain

  I know I am most likely using incorrect terminology so please correct me if I use the wrong terms so I can search better. We have a very large database at a client's site and we would like to have up to date copies of some of the tables sent across the internet to our servers at our office. We…

  Read the article

• select backup system

  - by Xaver

  how to better organize backup system in company over 1000 PC. what are the solutions and what their weaknesses?

  Read the article

• Keyboard shortcut to select any word and search the default search engine using the selected word(s)

  - by detj

  I want to search google or whatever the default search engine is set in the browser, by selecting a few words in the web page. Can I do this with a simple shortcut, instead of copy pasting the word in the search box and hitting enter?

  Read the article

• On HP Mini, unable to select 800x600 resolution

  - by Roboto

  I have an HP Mini laptop. I can only make resolution setting for my display of 1024x576. The HP Deskjet 6988 driver only allows resolution settings of 800x600. I don't care how 800x600 would look on my laptop, I only want to install the driver for the printer and set it back. I went into the…

  Read the article

• Linux filesystem suggestion for MySQL with a 100% SELECT workload

  - by gmemon

  I have a MySQL database that contains millions of rows per table and there are 9 tables in total. The database is fully populated, and all I am doing is reads i.e., there are no INSERTs or UPDATEs. Data is stored in MyISAM tables. Given this scenario, which linux file system would work…

  Read the article

• SQL COUNT records in table 2 JOINS away

  - by Fred K

  Using MySQL, I have three tables: projects: ID name 1 "birthday party" 2 "soccer match" 3 "wine tasting evening" 4 "dig out garden" 5 "mountainbiking" 6 "making music" batches: ID projectID templateID when 1 1 1 7 days before 2 1 1 …

  Read the article

• Possible to exclude or reorder a column from `*` ?

  - by Earlz

  Is it possible to exclude a column from a select * from table statement with SQL Server? I have a need for this and this is my only option other than parsing a raw SQL string to get out the required field names (I really don't want to do that). Just to be bold. When the query is…

  Read the article

• Possible to exclude a column from `*` ?

  - by Earlz

  Is it possible to exclude a column from a select * from table statement with SQL Server? I have a need for this and this is my only option other than parsing a raw SQL string to get out the required field names (I really don't want to do that). Just to be bold. When the query is…

  Read the article

• Fun with Aggregates

  - by Paul White

  There are interesting things to be learned from even the simplest queries.  For example, imagine you are given the task of writing a query to list AdventureWorks product names where the product has at least one entry in the transaction history table, but fewer than ten. One…

  Read the article

• Fun with Aggregates

  - by Paul White

  There are interesting things to be learned from even the simplest queries.  For example, imagine you are given the task of writing a query to list AdventureWorks product names where the product has at least one entry in the transaction history table, but fewer than ten. One…

  Read the article

• How do I access column data in a previous select statement from a sub-query? [closed]

  - by payling

  PROBLEM How do I access column data in a previous select statement from a sub-query? Below is a simple mock up of what I'm attempting to do. Tables used: Quotes, Users QUOTES TABLE qid, (quote id) owner_uid, creator_uid SQL SYNTAX: SELECT q.qid, q.owner_uid,…

  Read the article

• How to autosum value on dropdown and radio select

  - by Wilf

  I'm working on an auto calculation form which is a total column will change after a radio and a dropdown is clicked. I can make the total change for both dropdowns but the problem occurs when I tried to add a radio option. Here is my code. HTML Ages 10+: <select…

  Read the article

• INNER JOIN syntax for mySQL using phpmyadmin

  - by David van Dugteren

  SELECT Question.userid, user.uid FROM `question` WHERE NOT `userid`=2 LIMIT 0, 60 INNER JOIN `user` ON `question`.userid=`user`.uid ORDER BY `question`.userid returns Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL…

  Read the article

< Previous Page | 80 81 82 83 84 85 86 87 88 89 90 91  | Next Page >