Search Results

Search found 18566 results on 743 pages for 'query hints'.

Page 515/743 | < Previous Page | 511 512 513 514 515 516 517 518 519 520 521 522  | Next Page >

• An Alternative to Views?

  - by Abs

  Hello all, I am just reading this article and I came across this: Filter: Remove any functions in the WHERE clause, don't include views in your Transact-SQL code, may need additional indexes. If I do not use views, what are the alternatives? I mean, in my situation, I want to select some data from a table and then use a few other select queries to work on the subset of data from the first select query? How can I do this efficiently? Thanks all

  Read the article

• Oracle: how to "group by" over a range?

  - by Mark Harrison

  If I have a table like this: pkey age ---- --- 1 8 2 5 3 12 4 12 5 22 I can "group by" to get a count of each age. select age,count(*) n from tbl group by age; age n --- - 5 1 8 1 12 2 22 1 What query can I use to group by age ranges? age n ----- - 1-10 2 11-20 2 20+ 1

  Read the article

• Google GSA Stems for scandinavian languages

  - by HAXEN

  I have installed Scandinavia-2.1-1 language bundle to our GSA. After that I expected to find those languages available in Query Expansion, but nope nothing new there. Am I missing something? How are you other Scandinavians handling stems for your language?

  Read the article

• deadlocked on lock | communication buffer resources

  - by Robert Wilkinson

  Do all deadlocks indicate a problem with the query or does this kind deadlock indicate a problem with something else like SQL mail or something? The stored proc in question uses SQL mail.

  Read the article

• NHibernate join and projection properties

  - by devgroup

  Hello, I have simple situation (like on the image link text) and simple SQL query SELECT M.Name, A.Name, B.Name FROM Master M LEFT JOIN DetailA A ON M.DescA = A.Id LEFT JOIN DetailB B ON M.DescB = B.Id How to achive the same effect in nHibernate using CriteriaAPI ?

  Read the article

• JPA: How do I get a scalar result of type Long-- not BigNumber-- from Oracle NUMBER?

  - by rektide

  The default mapping from an Oracle NUMBER value is into BigNumber... How can I get a scalar result query to return a Long instead?

  Read the article

• postgres subquery w/ derived column

  - by Wells

  The following query won't work, but it should be clear what I'm trying to do: split the value of 't' on space and use the last element in that array in the subquery (as it will match tl). Any ideas how to do this? Thanks! SELECT t, y, "type", regexp_split_to_array(t, ' ') as t_array, sum(dr), ( select uz from f.tfa where tl = t_array[-1] ) as uz, sc FROM padres.yd_fld WHERE y = 2010 AND pos <> 0 GROUP BY t, y, "type", sc;

  Read the article

• mysql rollback when auto commit is on

  - by devang

  hi, by mistake i fired a update query and all the records in the table in dat field got updated nd also cannot rollback as auto_commit is on..is der ny other way in which i can retreive the records.plz help its urgent.. Thanks in advance

  Read the article

• Main Memory Database with C++ Interface

  - by myahya

  I am looking for a main memory database with a C++ interface. I am looking for a database with a programmatic query interface and preferably one that works with native C++ types. SQLLite, for example, takes queries as string and needs to perform parsing ... which is time consuming. The operations I am looking for are: Creation of tables of arbitrary dimensions (number of attributes) capable of storing integer types. Support for insertion, deletion, selection, projection and (not a priority) joins.

  Read the article

• IEnumerable<string> => unique string[]

  - by Maxim

  Hello, i have collection of IEnumerable (sentence = string) i want to split all sentences to words (ex: .Select(t = t.Split(' ')); and after i need group this query by words to get list of unique words. Please, Help

  Read the article

• what's wrong with this function?

  - by Joann

  function get_ibo_id() { if($registerquery = $this->conn->query("SELECT ibo_id FROM fasttrack WHERE count < 8 && flag = 1 ")){ $this->increase_count(); while ($row = $registerquery->fetch_assoc()) { return $row[ibo_id]; } } else return "No id"; } it always enters the if block even if the condition is not satisfied... going crazy

  Read the article

• Android: how to get the walking distance between two geo coordinats?

  - by wei

  I used this query URL http://maps.google.com/maps?q=from+A+to+B&output=kml ,which is given in the answer to this question. But after I tried it, it doesn't work with coordinates. It works with address names tho. I guess I could use google's geocoding to get the addresses first. But I wonder if there is another way to get the walking distance between two coordinates?

  Read the article

• database assignment

  - by eric

  Hi, Given the following table: CREATE TABLE T1 (A INTEGER NOT NULL); CREATE TABLE T3 (A SMALLINT NOT NULL); INSERT T1 VALUES (32768.5); SELECT * FROM T1; INSERT T3 SELECT * FROM T1; SELECT * FROM T3; What is the output of above query? If any error occured please declare the line of it?Explain your answer!

  Read the article

• Update table of two different database

  - by chetan

  This is the query to update table in one database that is of other Update test.temp a, test2.temp b Set a.name=b.name Where a.no=b.no; Now I don't want to write every field i.e a.name=b.name Is there any solution?

  Read the article

• importing and appending results of queries from different db in one db

  - by user316833

  I have 1000+ access files. Each file has a query named "overview" that has the same fields in each of the 1000 files. I need to import the results of these 1000+ overview queries into one single access db and append them into one table. Is there an automated way to do this? Thanks very much.

  Read the article

• Where am I going wrong with the count in Hql

  - by Bipul

  So I only want the count of the results not the results themselves therefore I am using count in hql. So, below is the query (int) Session.CreateQuery("select count(*) from TableName where Lhs=Rhs").UniqueResult(); But it is giving me the error Specified cast is not valid.. So, can any body tell me how to cast the count to int. Any help is very much appreciated.

  Read the article

• Problems with MySQL OR clause

  - by Simon

  I have a problem with AND and OR clause in SQL. Here is my query: SELECT `act1`.`name`, `act1`.`surname`, `act2`.`name`, `act2`.`surname`, `act3`.`name`, `act3`.`surname` FROM `videos`, `actors` AS act1, `actors` AS act2, `actors` AS act3 WHERE `videos`.`ident` = 'somethink' AND ( `act1`.`id` = `videos`.`id_actor1` OR `act2`.`id` = `videos`.`id_actor2` OR `act3`.`id` = `videos`.`id_actor3` ) It returns me all variations of {name, surname}, but I want the name and surname of first exactly, second and thirth, if they exist.

  Read the article

• Why isn't this simple MySQL statement working?

  - by Clark

  I am trying to match a user inputted search term against two tables: posts and galleries. The problem is the union all clause isn't working. Is there something wrong with my code? $query = mysql_query(" SELECT * FROM posts WHERE title LIKE '%$searchTerm%' OR author LIKE '%$searchTerm%' OR location LIKE '%$searchTerm%' OR excerpt LIKE '%$searchTerm%' OR content LIKE '%$searchTerm%' UNION ALL SELECT * FROM galleries WHERE title LIKE '%$searchTerm%' ");

  Read the article

• How does IIS persist a user's identity from page to page?

  - by Rising Star

  Web pages are, by nature, state-less objects. When you click from page to page in an ASP.net application, each request for a page is treated as a brand-new request. We use things like cookies, session-variables, and query strings to maintain state from page to page. When you log in to an ASP.net web application using Windows Authentication, how does IIS persist your identity between pages?

  Read the article

• Oralce : select maximum value from different comulms of the same row

  - by gregseth

  The whole question is pretty much in the title. For each row of the table I'd like to select the maximum of a subset of columns. For example, from this table name m1 m2 m3 m4 A 1 2 3 4 B 6 3 4 5 C 1 5 2 1 the result would be name max A 4 B 6 C 5 The query must be compatible oracle 8i. Thanks.

  Read the article

• Codeigniter: Get affected fields in update

  - by Roberto

  There's a way to get which fields were modified after a update query? I want to keep track what field XXX user modified... any ways using active records?

  Read the article

• Is there any sql interpreter for objects?

  - by Behrooz

  Is there any interpreter that takes a string or even a custom object as input and execute it on my datasource? I cannot use linq to object because query always changes and the report i'm working on, has about 6000 queries which i can reduce to 9 if i find some tool doing that for me. Opensource is very applicable. thanks in advance.

  Read the article

• Large Table in iFrame crashes IE8

  - by Brian

  I have a page with an iFrame whose source is an ashx page. The handler takes in 3 arguments through the query string and generates a text/html response containing a table. When the table gets 1700 rows it crashes the IE8 browser. The browser freezes and returns a null reference error. If I take the html that is being rendered and place it inside a DIV on the page it renders fine in IE8. Any suggestions?

  Read the article

• saving the FOR XML AUTO results to variable in SQL

  - by petergo

  select @[email protected]('*') for xml raw,type Above statement will generate following alert: Msg 6819, Level 16, State 3, Line 2 The FOR XML clause is not allowed in a ASSIGNMENT statement.

  Read the article

• SELECT table name that is inside UNION

  - by LexRema

  I have two same tables. I need to union them in such way: SELECT f1,f2, xxx FROM (SELECT * FROM tbl1 UNION ALL SELECT * FROM tbl2) where xxx would query for a table name, where f1 and f2 fields are taken from. Example output: 123 345 'tbl1' -- this rows are from the first table 121 345 'tbl1' 121 345 'tbl1' 123 345 'tbl1' 124 345 'tbl1' 125 345 'tbl2' -- this rows are from the second table 127 345 'tbl2' Thank you in advance.

  Read the article

< Previous Page | 511 512 513 514 515 516 517 518 519 520 521 522  | Next Page >