Search Results

Search found 5233 results on 210 pages for 'a records'.

Page 14/210 | < Previous Page | 10 11 12 13 14 15 16 17 18 19 20 21  | Next Page >

• deleting records from multiple tables at a time with a single query in sqlserver2005

  - by sudhavamsikiran

  Hi I wanna delete records from child tables as well as parent table with in a single query. please find the query given below. here response header is the primary table and responseid is the primary key. DELETE FROM responseheader FROM responseheader INNER JOIN responsepromotion ON responseheader.responseid = responsepromotion.ResponseID …

  Read the article

• Symfony - Delete and reload all database records for each test

  - by Andree

  Hi there, From the Jobeet tutorial provided in Symfony website, I found out that I can load fixtures data each time I run unit test by using this script: Doctrine_Core::loadData(sfConfig::get('sf_test_dir').'/fixtures'); However, I want to delete and reload all records from database each time I run a unit test. Currently, I'm doing this…

  Read the article

• SQL server 2005 :Updating one record from 2 identical records

  - by Shyju

  I have 2 records in a table in SQL Server 2005 db which has exactly same data. I want to update one record.Is there anyway to do it?Unfortunately this table does not have an identity column and i cant use a direct update query because both will be updated since data is same.Is there anyway using rowid or something in SQL server 2005 ?

  Read the article

• Create Directory for records in MS Access 2007

  - by glinch

  Hi there, Is it possible to create a directory folder for individual records in Access 2007. For example tblUser ID firstName surName When adding a record, would create a folder C:\userdatabase\Surname,firstName,ID Could see this being useful in situations for example where a large amount of images/files would need to be associated…

  Read the article

• Import 5 millions records to the rails application

  - by Bogdan Gusiev

  We need to import large amount of data(about 5 millions records) to the postgresql db under rails application. Data will be provided in xml format with images inside it encoded with Base64. Estimated size of the xml file is 40GB. What xml parser can handle such amount of data in ruby? Thanks.

  Read the article

• Bulk Insert multiple records and get identity for all using ADO.NET

  - by Hasan Khan

  I want to batch insert multiple records in sql server database using ADO.NET command/sqldataadapter and get identity value generated for all the rows in a single database trip. What are my options?

  Read the article

• How to select the last two records for each topic_id in MySQL

  - by Luca Romagnoli

  Hi. I have to select the last two records for every topic. ex: table: msg id | topic_id ------------ 1 | 1 2 | 1 3 | 1 4 | 1 5 | 2 6 | 2 7 | 2 8 | 3 9 | 3 10 | 3 I want to obtain these rows: 3 1 4 1 6 2 7 2 9 3 10 3 How can I do this? thanks

  Read the article

• Many returned records cause stackoverflow with Hibernate

  - by mimi law

  If there are many return records from DB. It will get stackoverflow problem. User is a class, which has a one to many relationship (to 3 other classes). When I print out the SQL, i found that the system runs the same query many time to get the data from DB. Does anyone know what the problem is? …

  Read the article

• Get records which not starts with alphabet in linq

  - by Prasad

  I need to get the list of records that does not starts with alphabets. i.e. Which starts with numeric and any special character. I am using asp.net mvc (C#) for my application. Whats the simple linq query to get this list?

  Read the article

• Get records using left outer join

  - by Devendra Gohil

  I have two tables as given below Table A Table B Table C ============= ============== ========= Id Name Id AId CId Id Name 1 A 1 1 1 1 x 2 B 2 …

  Read the article

• Filtering records in controller

  - by Elliot

  So in my model, there is a field user_id - which holds the ID of the user who created the record. To display the ID of the current user, I have @current_user.id My question is this, in the controller I want @posts to only have records created by @current_user.id how can I do this?

  Read the article

• executing null values records

  - by jjj

  i am trying to execute the records that have TotalTime null value from the table NewTimeAttendance...TotalTime datatype nchar(10) select * from newtimeattendance where TotalTime = 'NULL' ....nothing select * from newtimeattendance where TotalTime = 'null' ....nothing select * from…

  Read the article

• Inserting records into Berkeley DB with Java

  - by mrbombastic

  I can't seem to find sample code for constructing a Berkeley DB in Java and inserting records into it. Any samples? And I do not mean the Berkeley DB Java Edition either.

  Read the article

• get records from sqlite group by month

  - by peacmaker

  hi i hve an sqlite db which contain transactions each transaction has an price and has an transDate i want to retrieve the sum of the transaction group by month so the retrieved records should be like the following Price month 230 2 500 3 400 4 pleas any help

  Read the article

• web drop-down combo box with large list of records

  - by AlejandroR

  The amount of records to be displayed in drop-down combo boxes affect the performance of internet applications. What are the current best practices to solve this problem? Are paginated drop-downs the only solution? What is considered a large list? 100 or 1000?

  Read the article

• 100k+ Records and sp_xml_preparedocument

  - by Jonn

  I've been encountering a seeming deadlock with one of my tables and the only place I can trace it back to is a stored procedure that uses sp_xml_preparedocument on a list of data. The data inserted, btw, consists of a 100k+ records on average. Is it possible that it is causing the…

  Read the article

• SQL Query to delete records older than two years

  - by Garrett Dumas

  I need to clean out a very bloated SQL database by deleting records that are older than two years from a number of tables. What is the most efficient way of doing this? Thanks in advance.

  Read the article

• get the records for the latest timestamp mysql

  - by user295189

  how do I get all the records for latest date. The date filed in my db is called recordEntryDate and it is in this form 2010-01-26 13:28:35 Lang: php DB: mysql

  Read the article

• SQL ENQUIRY In how to Get defined number of records

  - by ramadan2050

  I have a select statement, retrieve about 1000 record I want to modify it to return only some records defined by @startIndex and @count e.g. : If I said @startIndex=20 and @count=20 the result will be : from the 21th record to 40th I try to make it, but it take the same time as…

  Read the article

• mysql select records greater than 3 months

  - by fire

  I am trying to write a query to select all records from users table where User_DateCreated (datetime field) is = 3 months from today. Any ideas? Thanks!

  Read the article

• select records from table in the order in which i inserted

  - by echo

  consider a tale is as follows, EmployeeId | Name | Phone_Number Now, i insert 10 records... When i query them back, select * from myTable they are not selected in the order i inserted. I can obviously keep an autoincrement index and ORDER BY index. But i dont want to alter the…

  Read the article

• add new records using signal in django admin

  - by ganesh

  I've a model called broadcastinfo, It has fields viz.. info,userid...userid is excluded. when i add an new info, my broadcastinfo table should get the records of all userid from user table and the given message. Im trying this via signal.Any idea is highly appreciated. Thanks

  Read the article

• mysql - How select a akin records?

  - by zeroonea

  I have a table with name varchar address varchar country varchar city varchar ..... to store address of location example: name|address|country HaLong hotel|156 blahblah street|Vietnam Hotel Ha Long|156 blah blah|Vietnam Two rows above is duplicate data. I have a form,…

  Read the article

• Get records from a specific month using SQLite

  - by soren121

  How would I write a SQLite query to select all records from a specific month? My dates are stored as Unix timestamps. PHP code is allowed in your solution if it's required. SQLite2-compatible queries only, please. :)

  Read the article

• Randomly selecting a limited number of records with two conditions in MySQL

  - by andyashton

  I have a MySQL table with a column called "priority". The column can have two values: high or low. I want to select 8 records from the table at random, but I want 6 of them to be high priority, and 2 of them to be low priority. If possibly, I would like to do it in one SQL…

  Read the article

< Previous Page | 10 11 12 13 14 15 16 17 18 19 20 21  | Next Page >