Search Results

Search found 19093 results on 764 pages for 'max path'.

Page 40/764 | < Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >

• varchar(255) to varchar(MAX)

  - by JD

  Is it possible to change a column type in a MS SQL 2008 database from varchar(255) to varchar(MAX) without having to drop the table and recreate? SQL Server Management Studio throws me an error every time I try to do it using that - but to save myself a headache would be nice to know if I can change the type without having to DROP and CREATE. Thanks

  Read the article

• Limiting max speed of sockets

  - by Lodle

  I'm using raw sockets on windows and I'm trying to find a way to limit the max connection speed over a group of sockets. For example I have 3 sockets to 3 servers and want to limit total download speed to 1mb. I googled and cant find any thing related. Any ideas?

  Read the article

• How do I select the max value from multiple tables in one column

  - by Derick

  I would like to get the last date of records modified. Here is a sample simple SELECT: SELECT t01.name, t01.last_upd date1, t02.last_upd date2, t03.last_upd date3, 'maxof123' maxdate FROM s_org_ext t01, s_org_ext_x t02, s_addr_org t03 WHERE t02.par_row_id(+)= t01.row_id and t03.row_id(+)= t01.pr_addr_id and t01.int_org_flg = 'n'; How can I get column maxdate to display the max of the three dates? Note: no UNION or sub SELECT statements ;)

  Read the article

• SQL - fetch the row which has the Max value for a column

  - by Umang

  Table: UserId, Value, Date. I want to get the UserId, Value for the max(Date) for each UserId. That is, the Value for each UserId that has the latest date. Is there a way to do this simply in SQL? (Preferably Oracle) Thank in advance! [Update:] Apologies for any ambiguity: I need to get ALL the UserIds. But for each UserId, only that row where that user has the latest date.

  Read the article

• Max size iPad / iPhone Offline Application Cache

  - by Rien

  Anyone knows the max size of Safari's 'Offline Application Cache' on the iPad & iPhone. Looks like it's 5MB. Is there any way to enlarge this size? Offline application cache docs: http://developer.apple.com/safari/library/documentation/iPhone/Conceptual/SafariJSDatabaseGuide/OfflineApplicationCache/OfflineApplicationCache.html

  Read the article

• VS 2010: Max line length guide does not render

  - by bstack

  In VS 2008, we were able to add a max line length guide ref: http://blog.feradz.com/2009/02/add-line-length-marker-in-visual-studio/ However when we attempt to do the same thing in VS 2010, it does not work. Does anyone know how to achieve this in VS 2010?

  Read the article

• How many max number of lines of code one .cs file should hold

  - by NewAutoUser

  How many max number of lines of code one .cs file should hold. Are there any industry standards/best practices for the same.

  Read the article

• Error with varchar(max) column when using net.sourceforge.jtds.jdbc.Driver

  - by Rihan Meij

  Hi I have a MS SQL database running (MS SQL 2005) and am connecting to it via the net.sourceforge.jtds.jdbc.Driver. The query works fine for all the columns except one that is a varchar(max). Any ideas how to get around this issues? I am using the jdbc driver to run a data index into a SOLR implementation. (I do not control the database, so the first prize solution would be where I can tweak the SQL command to get the desired results) Thanks

  Read the article

• MySQL VARCHAR like Data type with MIN and MAX character lengths

  - by Phill Pafford

  Looking for a data type that is similar to VARCHAR as to the values I would like, but is there a way to have a MIN/MAX character length? VARCHAR(6,10) This would have a minimum of 6 characters and a maximum of 10 characters.

  Read the article

• SQL - How to select a row having a column with max value

  - by Abhi

  date value 18/5/2010, 1 pm 40 18/5/2010, 2 pm 20 18/5/2010, 3 pm 60 18/5/2010, 4 pm 30 18/5/2010, 5 pm 60 18/5/2010, 6 pm 25 i need to query for the row having max(value)(i.e. 60). So, here we get two rows. From that, I need the row with the lowest time stamp for that day(i.e 18/5/2010, 3 pm - 60)

  Read the article

• Run a external program with specified max running time

  - by jack

  I want to execute an external program in each thread of a multi-threaded python program. Let's say max running time is set to 1 second. If started process completes within 1 second, main program capture its output for further processing. If it doesn't finishes in 1 second, main program just terminate it and start another new process. How to implement this?

  Read the article

• SQL Query To Get Multiple Max Values From Multiple Columns

  - by Sheridan

  I am trying to figure out how to pull multiple max values from multiple columns. Here is some sample data: DATE | A | B | C 4/4/2011 | 64.4 | 62.1 | 33.3 4/5/2011 | 34.6 | 33.5 | 32.3 4/6/2011 | 33.1 | 49.4 | 32.1 4/7/2011 | 55.2 | 32.8 | 33.5 4/8/2011 | 31.2 | 50.1 | 30.4 4/9/2011 | 31.7 | 31.1 | 30.4 I want the top 5 so: 4/4/2011 | 64.4 4/4/2011 | 62.1 4/7/2011 | 55.2 4/8/2011 | 50.1 4/6/2011 | 49.4 Thanks

  Read the article

• SQL Query for size of a nvarchar(max) column

  - by Jim

  I have a column which is of type nvarchar(max). How do I find the length of the string (or the number of bytes) for the column for each row in the table?

  Read the article

• Max (SQL-Server)

  - by rah.deex

  Hello everyone. I have a table that looks like this: BARCODE | PRICE | STARTDATE 007023819815 | 159000 | 2008-11-17 00:00:00.000 007023819815 | 319000 | 2009-02-01 00:00:00.000 How can I select so I can get the result like this: BARCODE | PRICE | STARTDATE 007023819815 | 319000 | 2009-02-01 00:00:00.000 select by using max date. Thanks in advance.

  Read the article

• Aggregate keeping the row with the max value

  - by Luca Bernardi

  Suppose you have the following schema (id, user_id , score). How can I take per each user the row with max score and then order all row for score. In other word I want a ranking where each user have his best result.

  Read the article

• Handle jQuery slider when min and max are same in values

  - by Ashwani K

  Hello All: I am using link text for implementing slider in my application, but it throws exception when the min and max values are equal. How can I handle such situation, any help on it? Thanks Ashwani

  Read the article

• SQL Query Help - Return row in table which relates to another table row with max(column)

  - by Seth

  I have two tables: Table1 = Schools Columns: id(PK), state(nvchar(100)), schoolname Table2 = Grades Columns: id(PK), id_schools(FK), Year, Reading, Writing... I would like to develop a query to find the schoolname which has the highest grade for Reading. So far I have the following and need help to fill in the blanks: SELECT Schools.schoolname, Grades.Reading FROM Schools, Grades WHERE Schools.id = (* need id_schools for max(Grades.Reading)*)

  Read the article

• Select get entire row corresponding to max in MySQL Group

  - by Brian

  When I use Max to find the maximum value of a field in a particular MySQL Group after using GROUP BY, is it possible to get the entire row which contains the maximum value?

  Read the article

• GtkLabel reset and GtkTextView max length

  - by stdio

  I've a NULL gtklabel. Upon the occurrence of an event, I set a text in this label (with gtk_label_set_text). How can I reset the gtklabel after the event (reset to NULL)? How can I set the max length (characters) of a GtkTextView? What's the easiest way to set the distance from the margin of a widget in a GtkTable?

  Read the article

• Grails/Hibernate max for string type

  - by bsreekanth

  Hello, In my table I have a serial number field, which is represneted by string.. It has a prefix and some numbers follow. Eg: ABC1234, ABC2345 etc. How to retrieve the largest value (max equivalent of int type) from this column. In my case it would be ABC2345. I probably could retrieve all the data,, sort it and get the same, but that would be slow. thanks in advance..

  Read the article

• Is there a better way to find the max count in a table

  - by nXqd

  select NV.PHG From Nhanvien NV Group by NV.phg Having count(nv.Manv) >= all (select count(NV.MANV from nhanvien nv group by nv.MANV)) I'm finding a better way to find the 'max count' NV of a PHG ( in this example ) . I think, we meet this case all the time when we do SQL, i should've a better way . Thanks for reading this :)

  Read the article

• php max() and min() on associative array

  - by stef

  print_r($pages); print max($pages); print min($pages); shows me Array ( [0] => 1 [1] => 2 [2] => 3 ) 1 2 While I was expecting the last two numbers to be 3 and 1. How come?

  Read the article

• Kubuntu - Can't move/max/min windows [closed]

  - by GregH

  All of a sudden it seems when ever I open a window on my Kubuntu (9.10) system, the windows dock in the upper left corner and can't be moved. There is nor border on the windows, no min/max/close buttons in the upper right corner of the windows. I tried opening a term window but it seems I can't type in the window. Any ideas what might be causing this?

  Read the article

• Quickest way to find the max frequency element in PHP

  - by Bruce

  I have an array of ids like 127415157,31323794... (range not known). What is the quickest way to find the max frequency ID in PHP? $array_ids = array()

  Read the article

• Finding the position of the max element

  - by Faken

  Is there a standard function that returns the position(not value) of the max element of an array of values? For example: say i have an array like this: sampleArray = [1, 5, 2, 9, 4, 6, 3] I want a function that returns the integer of 3 that tells me that sampleArray[3] is the largest value in the array.

  Read the article

< Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >