Search Results

Search found 17401 results on 697 pages for 'query optimizer'.

Page 147/697 | < Previous Page | 143 144 145 146 147 148 149 150 151 152 153 154  | Next Page >

• Return value from query statement - jQuery

  - by dave

  Hello, I have a ajax, jquery form which works fine, but returning a message from <div></div>. I want to return a value from a db query, a single value. How do I go about doing it. Thanks Dave

  Read the article

• Query results with no reverse

  - by gruber

  Hi, Ive got table: UserA, UserB, numberOfConnections I would like to write query which returns me only rows that has no reverse I mean or example : for data : 1 2 10 1 3 10 1 5 10 1 6 10 2 6 10 2 5 10 5 1 10 5 2 10 3 1 10 it should return 1 2 10 1 3 10 1 5 10 1 6 10 2 6 10 2 5 10 rows: 5 1 10 5 2 10 3 1 10 arent valid because there are already corresponding 1 5 10 2 5 10 3 1 10 thanks for help bye

  Read the article

• sql query returns incorrect result

  - by reza saberi

  I have a mysql database that stores quotation documents with some products that are clearly defining the price of each product in them, and a table for contracts storing contract details as well as customer code and quotation code to which it belongs. I have the following query to see how much is the total price of the quotation to write it in the invoice: select sum(sqproducts.price * sqproducts.quantity) as 'total-price', squotations.currency as 'currency' from sqproducts, ccontracts, squotations where sqproducts.contracted=1 AND squotations.code=sqproducts.quotation_code AND sqproducts.quotation_code=ccontracts.squotation_code AND sqproducts.quotation_code='QUOT/2012/1' group by currency

  Read the article

• Forming Xpath Query for total Google results

  - by user619879

  I've used this formula in Google Spreadsheets in the past to input the number of search results into a cell. The formula's not working anymore and I know I need to fix the xpath query. any ideas? Current formula: =importXML("http://www.google.com/search?num=100&q="&A2,"//p[@id='resultStats']/b[3]") Spreadsheet for public testing: https://spreadsheets8.google.com/ccc?key=tJzmFllp7Sk1lt23cXSVXFw&authkey=CM625OUO#gid=0

  Read the article

• Querying two tables with one query

  - by vipul

  I want to get two separate tables by executing one query in MySQL. If you know how, please reply.

  Read the article

• How to update two tables in a single query in MS SQL

  - by Aditya Acharya

  Can it be possible to update two tables writing single query. So that i do not to execute two queries and to track whether both are successful.

  Read the article

• Converting SQL Query to LINQ 2 SQL expression

  - by Shyju

  How can i rewrite the below SQL query to its equivalent LINQ 2 SQL expression (both in C# and VB.NET) SELECT t1.itemnmbr, t1.locncode,t1.bin,t2.Total FROM IV00200 t1 (NOLOCK) INNER JOIN IV00112 t2 (NOLOCK) ON t1.itemnmbr = t2.itemnmbr AND t1.bin = t2.bin AND t1.bin = 'MU7I336A80'

  Read the article

• How to convert map to url query string?

  - by Ula Krukar

  Do you know of any utility class/library, that can convert Map into URL-friendly query string? Example: I have a map: - "param1"=12, - "param2"="cat" I want to get: param1=12&param2=cat. PS. I know I can easily write it myself, I am just surprised that I cannot find it anywhere (I checked Apache Commons so far).

  Read the article

• Sql Query to list all views in an MS SQL Server 2005 database

  - by Matthias

  I need an sql query to enumerate all views (I only need the view names) of a specific database in MS SqlServer 2005. Thanks in advance!

  Read the article

• How to write SQL query as named_scope?

  - by keruilin

  How can I translate the following SQL query into a named_scope? select users.*, sum(total_quantity * total_price) as points_spent from orders join users on users.id = orders.user_id where pay_type = 'points' group by user_id order by points_spent desc Thanks!

  Read the article

• Query containing Logic

  - by Rosh

  empno emailID 1 [email protected] 2 [email protected] 3 [email protected] 2 [email protected] 1 [email protected] 1 [email protected] 3 [email protected] Write a query so that result will be :-- empno emailID 1 [email protected],[email protected],[email protected] 2 [email protected],[email protected] 3 [email protected],[email protected]

  Read the article

• HQl equivalent of sql query

  - by kash

  String SQL_QUERY = "SELECT count(*) FROM (SELECT * FROM Url as U where U.pageType=" + 1 + " group by U.pageId having count(U.pageId) = 1)"; query = session.createQuery(SQL_QUERY); I am getting an error org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 23 [ SELECT count() FROM (SELECT * FROM Url as U where U.pageType = 2 group by U.pageId having count(U.pageId) = 1)]

  Read the article

• Explain this SQL query in plain English.

  - by Kevinniceguy

  Please explain, in plain English, what question this SQL query answers: SELECT SUM(price) FROM Room r, Hotel h WHERE r.hotelNo = h.hotelNo and hotelName = 'Paris Hilton' and roomNo NOT IN (SELECT roomNo FROM Booking b, Hotel h WHERE (dateFrom <= CURRENT_DATE AND dateTo >= CURRENT_DATE) AND b.hotelNo = h.hotelNo AND hotelName = 'Paris Hilton');

  Read the article

• Android URLConnection GET query works WiFi but different response 3G

  - by kisplit

  Hey, I have some code which queries a web server using HTTP GET URLConnection connection = new URL("www.example.com" + "?blah=ok").openConnection(); connection.setRequestProperty("Accept-Charset", "UTF-8"); InputStream http_response = connection.getInputStream(); Now when I run this code while connected to WiFi I get the expected response but when I run this with WiFi disabled I instead seem to get the response of www.example.com without the appended query. Does anyone know why this is happening?

  Read the article

• kohana quotes in query.

  - by peter

  hey, i want to format a date in mysql using DATE_FORMAT(tblnews.datead, '%M %e, %Y, %l:%i%p') i cant seem to get the quotes right , so i keep getting errors. how would you put this in a query?

  Read the article

• update query with join on two tables

  - by dba_query

  I have customer and address tables. query: select * from addresses a, customers b where a.id = b.id returns 474 records For these records, I'd like to add the id of customer table into cid of address table. Example: If for the first record the id of customer is 9 and id of address is also 9 then i'd like to insert 9 into cid column of address table. I tried: update addresses a, customers b set a.cid = b.id where a.id = b.id but this does not seem to work.

  Read the article

• Which database invented the "limit" SQL query syntax?

  - by Howard

  MySQL has a nice feature (although non standard) which allow to query resultsets' limit, offset as SELECT * FROM TABLE LIMIT M, N; Is it created by MySQL? or Postgres?

  Read the article

• Help with SQL query in C#

  - by DanSogaard

  I'm trying to rename the columns. The syntax should be the column name between double quotes incase of two words, like this: SELECT p_Name "Product Name" from items So I'm trying to do it in C# code like this: string sqlqry1 = "SELECT p_Name \"Prodcut Name\" from items"; But I get an error: Syntax error (missing operator) in query expression 'p_Name "Prodcut Name"'. It seems am having somthing wrong with the quotes, but I can't figure out.

  Read the article

• Query for retrieving top two rows from a table in SQL Server

  - by Praveen

  Hi All, I have a table called Employee with EmpID,Salary,Name fields. I want to get top two employees with maximum salary. How can i write this query ?

  Read the article

• doctrine: save 20 users with one sql query?

  - by fayer

  i save a user like this in doctrine: $user = User(); $user->name = 'peter'; $user->save(); is there a way to save 20 users in one sql query? or do i have to loop the above code 20 times hence creating 20 sql queries? thanks

  Read the article

• query a XML with unknown elements and attributes

  - by Julien

  I want to query a xml file. I read this http://weblogs.asp.net/scottgu/archive/2007/08/07/using-linq-to-xml-and-how-to-build-a-custom-rss-feed-reader-with-it.aspx , But in my case i don't know the names of elements and attributes of the file. So i could i do ? Thanks

  Read the article

• mysql query timer for .net

  - by acidzombie24

  Is there something i can use to track how long my mysql queries take? perhaps log them if they take a certain amount of time? or track all queries but only hold the longest query time? using this with C# .NET with ASP.NET. I'd like to use this to occasionally check if my queries are getting slow.

  Read the article

• Ordering sql query results

  - by user343409

  My sql query gives the columns: product_id (which is an integer) pnl (which is float - can be negative) I get more than 100 rows. I want to filter out the top 40 rows based on abs(pnl). But the results should be ordered by pnl column only and not by abs(pnl). I want to do this for MSSQL 2005. Is there a way to do this?

  Read the article

• sql query without subquery

  - by user1285737

  I need to rewrite this query and I'm not allowed to use a subquery. I need to select the name and color of the parts that are heavier than the wheel. SELECT name, color FROM parts WHERE weight > (SELECT weight FROM parts WHERE name="wheel"); This is the table: PARTS ID NAME COLOR WEIGHT 1 wheel black 100 2 tire black 50 3 gear red 20 Thanks in advance

  Read the article

• sql server query/subquery question

  - by parminder

  Hi Experts, I have a tables with data like this Id BookId TagId 34 113421 9 35 113421 10 36 113421 11 37 113421 1 38 113422 9 39 113422 1 40 113422 12 I need to write a query (SQL Server) which gives me data according to the tags say if I want bookIds where tagid =9 it should return bookid 113421 and 113422 as it exists in both the books, but If I ask data for tags 9 and 10 it should return only book 113421 as that is the only book where both the tags are present. Thanks Parminder

  Read the article

< Previous Page | 143 144 145 146 147 148 149 150 151 152 153 154  | Next Page >