Search Results

Search found 38336 results on 1534 pages for 'sql wait types'.

Page 686/1534 | < Previous Page | 682 683 684 685 686 687 688 689 690 691 692 693  | Next Page >

• mysql: get all rows into 1 column

  - by andufo

  hi, i have 3 tables: post (id_post, title) tag (id_tag, name) post_tag (id_post_tag, id_post, id_tag) Lets suppose that id_post 3 has 4 linked tags 1,2,3,4 (soccer, basket, tennis and golf). Is there a way to return something like this in ONE row? col 1 id_post = 3 col 2 tags = soccer basket tennis golf Thanks

  Read the article

• performing more than one Where in query return null!!! why? how to fix this?

  - by Sadegh

  hi, i have wrote a method that filters output with provided query and return it. when one Where excuted; it return correct output but when more than one Where excuted; output is null and Exception occured with message "Enumeration yielded no results". why? how i can fix it? public IQueryable<SearchResult> PerformSearch(string query, int skip…

  Read the article

• Firebird: assign id to existing rows from newly added generator

  - by Aldo

  hello everyone, i have a table whixh contains some rows and dows not have a primary key. I want to add one now, but, is it possible for the existing rows to get an id from the newly added primary key? Dbms: firebird

  Read the article

• Data historian queries

  - by Scott Dennis

  Hi, I have a table that contains data for electric motors the format is: DATE(DateTime) | TagName(VarChar(50) | Val(Float) | 2009-11-03 17:44:13.000 | Motor_1 | 123.45 2009-11-04 17:44:13.000 | Motor_1 | 124.45 2009-11-05 17:44:13.000 | Motor_1 | 125.45 2009-11-03 17:44:13.000 | Motor_2 …

  Read the article

• How to select rows which start with digit in PostgreSQL?

  - by noxvile

  Need to get rows starting with digit e.g. '1test', '32 test'. I tried SELECT * FROM table WHERE name LIKE '[0-9]%' as I used to do in MSSQL but it wasn't successful.

  Read the article

• MySQL Query Join Table Selecting Highest Date Value

  - by ALHUI

  Here is the query that I run SELECT cl.cl_id, cc_rego, cc_model, cl_dateIn, cl_dateOut FROM courtesycar cc LEFT JOIN courtesyloan cl ON cc.cc_id = cl.cc_id Results: 1 NXI955 Prado 2013-10-24 11:48:38 NULL 2 RJI603 Avalon 2013-10-24 11:48:42 2013-10-24 11:54:18 3 RJI603 Avalon 2013-10-24 12:01:40 NULL The…

  Read the article

• Must read resources for NoSQL developers.

  - by Little Jeans

  Can you recommend any resources every NoSQL developer should be familiar with?

  Read the article

• Postgresql count+sort performance

  - by invictus

  I have built a small inventory system using postgresql and psycopg2. Everything works great, except, when I want to create aggregated summaries/reports of the content, I get really bad performance due to count()'ing and sorting. The DB schema is as follows: CREATE TABLE hosts ( id SERIAL PRIMARY KEY, name VARCHAR(255) );…

  Read the article

• How do I find the user that has both a cat and a dog?

  - by brad

  I want to do a search across 2 tables that have a many-to-one relationship, eg class User << ActiveRecord::Base has_many :pets end class Pet << ActiveRecord::Base belongs_to :users end Now let's say I have some data like so users id name 1 Bob 2 Joe 3 Brian pets id user_id …

  Read the article

• Temporary intermediate table

  - by user289429

  In our project to generate massive reports in oracle we use some permanent table to hold intermediate results. For example to generate one report we run few queries and populate the table, at the final step we join the intermediate table with huge application tables. These intermediate tables are cleared for next report run. We have…

  Read the article

• Assign values from same table

  - by Reddy S R

  I have a database table with parent child relationships between different rows. 1 parent can have any number of children. Children do not have children. I want to copy 'Message' from 'Parent Category' to child categories. CategoryID Name Value Message ParentID DeptId 1 Books 9 …

  Read the article

• Incorrect syntax near ')' calling storedproc with GETDATE

  - by Nat

  Maybe I am having a moment of 'afternoon', but can anyone explain why I get Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ')'. When running CREATE PROC DisplayDate ( @DateVar DATETIME ) AS BEGIN SELECT @DateVar END GO EXEC DisplayDate GETDATE();

  Read the article

• What does DataContext.GetTable<TEntry> do?

  - by Bryan

  Consider I have a DataContext db, and there is an Entity class User. So when System.Data.Linq.Table<User> table = db.GetTable<User>(); is called for the first time, does it pull the data from the database immediately, does it use deferred execution, or were the data already loaded from database when db was initialized?

  Read the article

• Calculate open timeslots given availability and existing appointments - by day

  - by Andre

  Overview: I have a table which stores a persons "availability" for a current day, e.g. Mon - 8:00am - 11:30am Mon - 1:30pm - 6:00pm A second table stores appointments that this person already has for the same day, e.g. Mon - 8:30am - 11:00am Mon - 2:30pm - 4pm Desired result: Doing calculationsI'd like to have the…

  Read the article

• acts-as-taggable-on: find tags with name LIKE, sort by tag_counts?

  - by James

  Hi I'm using the rails plugin acts-as-taggable-onand I'm trying to find the top 5 most used tags whose names match and partially match a given query. When I do User.skill_counts.order('count DESC').limit(5).where('name LIKE ?', params[:query]) This return the following error: ActiveRecord::StatementInvalid:…

  Read the article

• Conditional SELECT MySQL

  - by user188693

  Don't know if this is possible, but I'd like to select records based on the field value of recur_type, where the 'm' is the day of the week. If it's a weekly recurring event, I need to make sure this is a day it recurs on, otherwise, I want to return all days. however, I'm getting an empty result set: SELECT…

  Read the article

• Stored procedure with output parameters vs. table-valued function?

  - by abatishchev

  Which approach is better to use if I need a member (sp or func) returning 2 parameters: CREATE PROCEDURE Test @in INT, @outID INT OUT, @amount DECIMAL OUT AS BEGIN ... END or CREATE FUNCTION Test ( @in INT ) RETURNS @ret TABLE (outID INT, amount DECIMAL) AS BEGIN ... END What are pros…

  Read the article

• Databinding expression for retrieving value of related collection using LINQ

  - by joshb

  I have a GridView that is bound to a LINQDataSource control that is returning a collection of customers. Within my DataGrid I need to display the home phone number of a customer, if they have one. The phone numbers of a customer are stored in a separate table with a foreign key pointing to the customer…

  Read the article

• Deleting partial data from a field in MySQL

  - by Graham

  I am trying to remove a specific set of data from a MySQL database field, however I am not sure what the best statement would be for this. For example, if I have a data in a field such as... The use of a secondary password will allow you to gain access to your account from a non-authenticated…

  Read the article

• Ways to implement tags - pros and cons of each

  - by bobobobo

  Related Using SO as an example, what is the most sensible way to manage tags if you anticipate they will change often? Way 1: Seriously denormalized (comma delimited) table posts +--------+-----------------+ | postId | tags | +--------+-----------------+ | 1 |…

  Read the article

• explain these select statements!

  - by user329820

  Hi, I can not get the difference betwwn these statements? would you please help me,I have read some sample of select statements but I did not get these ones. SELECT 'B' FROM T WHERE A = (SELECT NULL); SELECT 'C' FROM T WHERE A = ANY (SELECT NULL); SELECT 'D' FROM T WHERE A =…

  Read the article

• How to apply GROUP_CONCAT in mysql Query

  - by Query Master

  How to apply GROUP_CONCAT in this Query if you guys have any idea or any alternate solution about this please share me. Helps are definitely appreciated also (see Query or result required) Query SELECT WEEK(cpd.added_date) AS week_no,COUNT(cpd.result) AS death_count FROM…

  Read the article

• Stored Procedure: Reducing Table Data

  - by SumGuy

  Hi Guys, A simple question about Stored Procedures. I have one stored procedure collecting a whole bunch of data in a table. I then call this procedure from within another stored procedure. I can copy the data into a new table created in the calling procedure but as far…

  Read the article

• Does introducing foreign keys to MySQL reduce performance

  - by Tam

  I'm building Ruby on Rails 2.3.5 app. By default, Ruby on Rails doesn't provide foreign key contraints so I have to do it manually. I was wondering if introducing foreign keys reduces query performance on the database side enough to make it not worth doing. Performance in…

  Read the article

• Returning records from 3 tables via a Join Table with Propel in Symfony

  - by Jon Winstanley

  I have 3 database tables: article article_has_tag (2 FK's to the other tables) tag I currently show a list of articles with the article's tags shown underneath but the number of queries grows as the list gets longer. I want to loop over all the articles and get the…

  Read the article

< Previous Page | 682 683 684 685 686 687 688 689 690 691 692 693  | Next Page >